Hi everyone, I am new here so I hope I don't mess this up. I am looking to do one of two things, preferably transfer data from 1 tab to multiple tabs.
I have a table on a sheet titled all data-enter information here. There are headings starting at B3 and going to N3. It starts at B3 so that I can have an index link on top and column A may eventually have numbers.
A B C D E F G H I J K L M N
Blank Name School KTF/ESP Home Address City State Zip Cell Phone Home Phone Home Email Work Email DOB Sick Bank Y/N
I would like to copy the data to individual tabs based on column C (school), and have the data update when changes are made to the sheet all data-enter information here. I already have the tabs set up, but could remove them if that is the easier route to take. The tabs are in order (KHS, JWB, MCM, Chambers, Crosby, Edson, GW, JFK, Myer)
I have tried multiple sites, youtube videos etc and all the codes are way too complicated and give me errors when I change where it should be changed. I KNOW part of it is that I want the data to start in column B, row 4 (headings in B3) but as I said I need to have the link to return to index.
If it is easier I could paste the data to the individual tabs and would just need a VBA to copy and update each tab to the master tab (all data-enter information here)
I know providing the file might be helpful but there is a ton of personal information here.
Thank you in advance for ANY help I can get.
Bookmarks