Copy Row in Excel to Specific Tabs [Closed]

Report
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
Hello,

I'm not very smart once I get outside of if-then formatting.

I have an excel worksheet. It is used to track purchases for different divisions of my company. A, B, C, D, E, F, 1, 2, 3, 4 are the divisions as they're identified on my master data page, titled FY 11

What I would like to happen is that any data entered into FY 11 that has the appropriate division listed in Column A would then populate over into the tab on the worksheet with corresponding identifier.

Example: Data entered into tab name "FY 11"
Cell A3 (the first line of data entry) has the entry "A". I would like excel to copy row 3 into row 3 of tab "A". (row 3 to allow me to input header information).

Thank you for your help, please let me know if I need to clarify anything.


1 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
798
if all the entries are made in the master sheet then you can transfer data for each division to that division sheet.

but if it is going to be dynamic that as you enter new data it should go to the division sheets there should be some way to identify the new entries

better post a very small extract of your master sheet.
also it is presumed that all the division sheets are opened

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!