Solved How do I automate copying selected data from one worksheet i

April 3, 2014 at 05:36:30
Specs: Windows XP
Multiple users enter Purchase Order info for all suppliers in to one spreadsheet. I want to automate it so that this information is duplicated into separate supplier worksheets enabling me to identify easily total spend YTD for each supplier

See More: How do I automate copying selected data from one worksheet i

Report •

April 3, 2014 at 07:30:04
✔ Best Answer
Without knowing the exact layout of your worksheets, it's hard to give a specific answer.

2 options come to mind:

1 - In each supplier worksheet use either VLOOKUP or INDEX-MATCH to pull supplier specifc data into each sheet.

2 - Use a macro to transfer the data once it has been entered. If you choose the macro route, then macros will need to be enabled on each user's system, something that has to be done at the user's workstation by the user or by someone authorized to perform that action. You can not "force" a system to enable macros without user interaction. That would be a serious security risk.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

April 4, 2014 at 04:03:14
Thanks for your response, it has helped me to rethink how I was going about this and get to a workable solution.

Report •
Related Solutions

Ask Question