Hi,
First post - go easy!
I'm wanting to set up a spreadsheet holding master data and lots of information within the first tab. However instead of pasting the information to the relevant worksheet I need a formula for it to pick up the relevant data and then move it to the correct worksheet.
For example:
If I have the word P AC selected on the master sheet it takes the name and d.o.b from the master-sheet and inserts that information to the P AC worksheet.
There are 13 potential worksheets where the mastersheet could send the info to.
Thanks in advance.
Jack
Bookmarks