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.