Skip to main content
Support is Offline
Today is our off day. We are taking some rest and will come back stronger tomorrow
Official support hours
Monday To Friday
From 09:00 To 17:30
  Tuesday, 07 November 2017
  2 Replies
  8.8K Visits
0
Votes
Undo
Hi!

I have found the "Copy Rows To New Sheet If Column Contains Specified Text/Value In Excel" tool, but I am actually looking to copy the row into an existing sheet, based on a column. As an example, I would like to have a sheet where all data would be entered and the separated in between the sheets, based on the name listed in column F, that would match the name of the sheet...

Is there a way to do so?

Regards!
Hi Jay,

I have attached the image since I am unable to attach any XLSX Files:
https://www.screencast.com/t/TL4OxLFORBI
https://www.screencast.com/t/4SgtoELHs3n

In other words, I would like to use the INVOICES sheet to enter the data, that would automatically copied and pasted to the sheet that corresponds to the Column A of the INVOICES sheet. In other words, I would love an automatic filter that would spread the information contained in the INVOICES Sheet in between the Account Name Sheets...

Same as this one https://www.extendoffice.com/documents/excel/3047-excel-copy-rows-to-sheet-based-on-column-value-criteria.html but in EXISTING sheets.
6 years ago
·
#1315
0
Votes
Undo
Hello,
Can you please try to create some sample data in an Excel file to demonstrate the operation?
Or please try to create some screenshots to demonstrate the operation.
Thanks in advance.
  • Page :
  • 1
There are no replies made for this post yet.