Help with lookup issue...

[aswert1223]

Thanks for the answer JulieD!

I'm starting each month with a workbook with pre-made worksheets fo
each day's automated report, and a premade worksheet for each Agent.
Each day the report for that day Is pasted into the proper day'
worksheet. This sheet is analysed for daily performance of the entir
group. I have this process working already.

What I'm trying to do is have each Agent's monthly report import th
row's data for each day the Agent works as the daily report i
entered.

I'm trying to avoid VB or macros (the person who will use this repor
is a complete Excel novice...even moreso than I ).

Jac

 

[JulieD]

Hi Jack

I think we'll have to go down the VBA route if you want to do this
"automatically" ... but what i need to know is how are the sheets "named"
and how "automatic" do you want the transfer - every time something is typed
into a line (not recommended), when the next day's sheet has an entry in the
first cell, or a "update agent's info now" button (my preferred option).

it might be easier if you'ld like to send me the workbook so i can see the
exact structure - please email it to me direct at julied_ng at hcts dot net
dot au

Cheers
julieD