Hi Guys, I have been looking all over the web for a working formula for the following. I feel I cannot be the first person to want to do something like this, or maybe its not possible.. Im not sure. Here is my requirement (I hope I am thorough enough):
GOAL: To auto populate the MONTH sheets with the relevent MONTH clients.
WORKBOOK1
SHEET 1 = Clients
SHEET 2 = JANUARY
SHEET 3 = FEBRUARY
...etc
CLIENTS
Row A
A2 - JAN
B2 - Client Number (numberic)
C2 - Client Name
D2 - Client Location
JANUARY
A2 - if CLIENT A2 = JAN - I want to copy B2 from sheet 1 into A2 of Sheet 2
I can actually do this.. but I have an additional requirement:
JANUARY
B2 Cell - If A2 = Client number, lookup client number in CLIENTS and get specific cells from the row that has the CLIENT NUMBER.
The end goal would be (as an example), if row 22 had FEB in the A column.. then it would automatically go to the FEBRUARY sheet and so on with the remaining months of the year.
Is that helpful so that you guys can be helpful?
Thanks in advance!
Dave
Bookmarks