Hi,
I have to change something in one of my projects (reports) and i think i am
going crazy, i really need your help.
I have a report with 2 worksheets.
In the first one i have columns for: acct#, acct name, address, phone.......
In the second worksheet i have again acct# (vlookup from first worksheet),
acct name (vlookup from first worksheet) and another 31 columns with days of
the month.
The sales rep will add in each day a number (how many hours they spend in
that day for that account).
So far so good. Now if an Sales rep is adding a new account in the first
worksheet, they have to arrange the accounts ascending (vlookup is working
just with ascending numbers) in the second worksheet will be a mess.
The acc # and acc name will be fine but the hours (numbers) will not match
anymore the correct accounts.
I need somehow to keep together the acc # + acc name + hours( the all row
with numbers for each account) after we add a new account and we rearrange
ascending all the accounts.
Please help.
Thanks,
Alex