Log in
x
or
x
x
Register
x

or
×

normal Copy rows to EXISTING sheet based on specific criteria of a column of the row

  • mhardy@crakmedia.com
  • mhardy@crakmedia.com's Avatar Topic Author
  • Offline
More
2 years 3 months ago #266 by mhardy@crakmedia.com
Hi Jay,

I have attached the image since I am unable to attach any XLSX Files:



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 How to copy rows to new sheet based on column criteria in Excel? but in EXISTING sheets.

Please Log in or Create an account to join the conversation.

More
2 years 3 months ago #261 by qiuhongkun
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.

Please Log in or Create an account to join the conversation.

  • mhardy@crakmedia.com
  • mhardy@crakmedia.com's Avatar Topic Author
  • Offline
More
2 years 3 months ago #258 by mhardy@crakmedia.com
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!

Please Log in or Create an account to join the conversation.

Moderators: jaychivoExcelfansqiuhongkun