Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or
×

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

  • MCHardy
  • Topic Author
  • Offline
  • New Member
  • Nouveau membre
More
1 year 5 months ago #266 by MCHardy
Hi Jay,

I have attached the image since I am unable to attach any XLSX Files:
11.08.2017-11.39.02
11.08.2017-11.39.24

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
1 year 5 months ago #261 by Jay Chivo
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.

  • MCHardy
  • Topic Author
  • Offline
  • New Member
  • Nouveau membre
More
1 year 5 months ago #258 by MCHardy
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.

  • Not Allowed: to create new topic.
  • Not Allowed: to reply.
  • Not Allowed: to edit your message.
Moderators: jaychivoJay Chivo