[Solved] attendance sheet-copy formula

[beeker]

Hello all, I am sure there is an easy answer for this, I just don't know it.

I have attached a spreadsheet that has 3 worksheets, summary and 2 individual. I am trying to drive the individual sheets from the summary page.

Basically, I enter the week ending and hours worked and the individual sheets would retain the accumulated individual info.
The formula I am using is as follows:
=IF(A5='Week End'!$B$2,'Week End'!$B$4,"")
What I have discovered is that as I change weeks the prior week become blank, just like I told it too!.
Is there a copy command I can use in a formula to copy or some other way to save the prior weeks info? I thought about Lookup but would run across the same problem.

Any help would be appreciated,
Thanks
Beeker

[Jas]

Copy, then

Edit
Paste Special...
Values

[beeker]

Please look at the spreadsheet as I am needing to imbed the copy command into a formula:
I know this formula doesn't work but something like:

=IF(A5='Week End'!$B$2,'Week End'!$B$4 and copy [b]value[b] $b$4 to $g$4,"")


Beeker

[rem1224]

Hi Beeker,

Have a look at the attached.
I added a macro to your file to copy over all the data on the Week End sheet to the individual sheets.

If the employee does not have a sheet, a new sheet is created and formatted (the sheet has to be named the exact same as the data in Col A).

A new line is added on to the end of the employees sheet with the current week and data.

Hope this helps

.....Ralph

[beeker]

Thanks, I think this should work. The problem I have run into is:
If the update is run twice with the same week ending date, it also updates the individual sheets with a duplicate week ending date.
Do I put an "If" statement in each cell or can something be imbedded into the Macro?

Thanks
Beeker

[rem1224]

Hi Beeker,

Just tell the operator not to do that :biggrin:

Seriously though, I added a test to see if the update is a duplicate - shouldn't write double records now.

.....Ralph

[beeker]

Perfect, thanks for the help.

To bad I have to make everything so idiot proof!

Beeker