Thanks Simon for looking at the workbook; the Date is something I did
over-look but has been corrected. As for the formatting the entire sheet, it
is a mistake I do almost everytime; and often I end up having to start over
just because of that.
Thankyou for the advice, you've been a great help and I look forward to the
macro
regards
aussiegirlone
"JBeaucaire" wrote:
While Simon is working out the macro process, just a tip on layout
preparation: RESIST the urge to format columns down the entire worksheet.
On your posted sample, I went down to row 100 on the two employee sheets,
highlighted ALL the rows from 100 down and selected EDIT CLEAR ALL.
After doing that to the two sheets, and saving again, the size of your
workbook dropped from almost 5 MEGS to 70Kb.
You can add formatting as you go, or have your macro do that.
--
"Actually, I *am* a rocket scientist." -- JB
Your feedback is appreciated, click YES if this post helped you.
"Simon Lloyd" wrote:
Aussiegirlone;329380 Wrote:
Hello Simon
I finally got here so I hope you are still able to help Bg:)
original message:
I have created an Employees Roster have got 15 sheets each Titled as a
Site
Location. Then I have got another 15 sheets, each with the name of a
single
employee. What I would like to do is have the employees Roster Sheets
automatically search all the Site Sheets for the data entered. Thus,
what
ever is entered into the site sheets it automatically enters the data
into
the corresponding employee. If this is possible, can anyone help with a
formula or macro to do this?
attachment has been provided in case you are able to help.
PS: Thankyou for helping me so far :)
Regards
aussiegirlone
Aussiegirlone, having looked at your workbook structure you need to
clarify some things....in the employee sheet you have a column for Date
but in your patrol sites etc. you dont supply a date, finding and moving
data would be easier if the employees were prefixed with a date (those
without wouldn't be transferred) it could be that you may need to change
your structure a little.
Do you want to run the collection daily, weekly or monthly?
--
Simon Lloyd
Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=91647