Copy, then
Edit
Paste Special...
Values
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
Copy, then
Edit
Paste Special...
Values
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
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
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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks