Copy rows to EXISTING sheet based on specific criteria of a column of the row
By mhardy@crakmedia.com on Tuesday, 07 November 2017
Posted in Kutools for Excel
Replies 2
Likes 0
Views 9.4K
Votes 0
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!
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.
qiuhongkun
·
6 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
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.
mhardy@crakmedia.com
·
6 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post