Hello,
I'm trying to make it so when I input the word Intern in column J of the LA sheet (and many others, but this is a test), then info would move from that intern's column to the appropriate columns in the Roster sheet. Is this possible?
Hello,
I'm trying to make it so when I input the word Intern in column J of the LA sheet (and many others, but this is a test), then info would move from that intern's column to the appropriate columns in the Roster sheet. Is this possible?
The problem I see is that it appears you plan on using the ROSTER to edit and add more info. How do you plan on keeping the two sheets in sync if you make changes on the LA sheet after you've added more info to the Roster?
Last edited by JBeaucaire; 10-18-2010 at 03:19 PM.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Well I was hoping to have a button on my page that will auto transfer the data, so if I ever need to make a change to someone's info, I'd make it in the LA tab and then hit the transfer button. That would then transfer all rows with "Intern" in the Status column and sort them alphabetically by Last name in the Roster sheet. Would that work?
Last edited by aegliveinterns; 10-18-2010 at 02:23 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks