[Solved] attendance sheet-copy formula - Excel Help & Excel Macro Help
SEARCH ENTIRE SITE LOADING..

OZGRID Excel Help & Excel Best Practices Forums

Information Helpful? Why Not Donate.

SPECIALS PAGE FOR BARGAINS | BUILD YOUR GOLF SWING | FREE CUSTOM FUNCTIONS ADD-IN


Download Active Data For Excel Demo


Go Back Excel Help & Excel Macro Help > HELP FORUMS > EXCEL HELP
HOME Register Forum Help Calendar Search For Today's Posts Mark Forums Read

Closed Thread

[Solved] attendance sheet-copy formula

ANSWERS TO SIMILAR QUESTIONS
Copy & Paste A Sheet Progressive Formula (2)Controls for Attendance sheetAttendance sheet protection.[Solved] Formulas : Attendance problem attendance form-copy formula



Javascript DHTML Drop Down Menu Powered by dhtml-menu-builder.com

Create Excel dashboards quickly with Plug-N-Play reports.


 
Thread Tools Search this Thread
Old September 4th, 2003
Intelligent Converters
FREE DOWNLOADS
File/Password Recovery
beeker beeker is offline
Member
 
I'm a Spammer:
MS Office Version:
Op System:
Assumed Experience:
Join Date: 18th April 2003
English is 1st Language:
Posts: 42 -- Threads: 12
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
Print [Post / Thread]
Old September 4th, 2003
Jas's Avatar
Jas Jas is offline
Member
 
I'm a Spammer:
MS Office Version:
Op System:
Assumed Experience:
Join Date: 26th August 2003
English is 1st Language:
Location: Lost
Posts: 45 -- Threads: 14
Copy, then

Edit
Paste Special...
Values
Print [Post / Thread]
Old September 4th, 2003
Intelligent Converters
FREE DOWNLOADS
File/Password Recovery
beeker beeker is offline
Member
 
I'm a Spammer:
MS Office Version:
Op System:
Assumed Experience:
Join Date: 18th April 2003
English is 1st Language:
Posts: 42 -- Threads: 12
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
Print [Post / Thread]
Old September 4th, 2003
Intelligent Converters
FREE DOWNLOADS
File/Password Recovery
rem1224 rem1224 is offline
Established Member
 
I'm a Spammer: NO
MS Office Version: 2002(XP)
Op System: Windows XP
Assumed Experience: Above Average
Join Date: 27th June 2003
English is 1st Language: Yes
Location: Maryland, USA
Posts: 368 -- Threads: 3
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
Print [Post / Thread]
Old September 5th, 2003
Intelligent Converters
FREE DOWNLOADS
File/Password Recovery
beeker beeker is offline
Member
 
I'm a Spammer:
MS Office Version:
Op System:
Assumed Experience:
Join Date: 18th April 2003
English is 1st Language:
Posts: 42 -- Threads: 12
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
Print [Post / Thread]
Old September 5th, 2003
Intelligent Converters
FREE DOWNLOADS
File/Password Recovery
rem1224 rem1224 is offline
Established Member
 
I'm a Spammer: NO
MS Office Version: 2002(XP)
Op System: Windows XP
Assumed Experience: Above Average
Join Date: 27th June 2003
English is 1st Language: Yes
Location: Maryland, USA
Posts: 368 -- Threads: 3
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
Print [Post / Thread]
Old September 6th, 2003
Intelligent Converters
FREE DOWNLOADS
File/Password Recovery
beeker beeker is offline
Member
 
I'm a Spammer:
MS Office Version:
Op System:
Assumed Experience:
Join Date: 18th April 2003
English is 1st Language:
Posts: 42 -- Threads: 12
Perfect, thanks for the help.

To bad I have to make everything so idiot proof!

Beeker
Print [Post / Thread]
Closed Thread Lifetime Upgrade To Ad Free Styles

   « PREVIOUS [Solved] Protecting cells in excel || using data stored in other spreadsheets NEXT »
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT +9. The time now is 20:27.


Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
Ozgrid is Not Associated With Microsoft. Ozgrid Retains the Rights to ALL Posts and Threads