Help with lookup issue...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

aswert1223 - 27 Oct 2004 17:40 GMT

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 :eek: ).

Jac

Reply to this Message

JulieD - 29 Oct 2004 09:31 GMT

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

> Thanks for the answer JulieD!
>
[quoted text clipped - 12 lines]
>
> Jack

Reply to this Message