Note: The other languages of the website are Google-translated. Back to English
English English
  Tuesday, 07 November 2017
  2 Replies
  4.6K 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!
5 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.
0
Votes
Undo
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.
  • Page :
  • 1
There are no replies made for this post yet.

Follow Us

Copyright © 2009 - www.extendoffice.com. | All rights reserved. Powered by ExtendOffice. | Sitemap
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.
Protected by Sectigo SSL