• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Excel help

H

Howard

Lifer
I would like to set up a spreadsheet with 5 worksheets in it; one worksheet for the entire month and one for each week (M-F). What needs to happen is that when I enter a new row of data into the monthly worksheet, the row gets copied into an empty row (preferably the "next" empty one) in the corresponding week - I guess it would just read the entered date.

What's the best way to get this done?
 
I don't have your answer, nor time to work it out, but if you have time, it should help you to look around here.

A lot of the listed Excel MVPs take questions on their individual web sites, linked there for you.
 
I'm not sure why you would want to duplicate data in other sheets. What is it that you are trying to accomplish?

It sounds like you could really be using a single sheet with a pivot table.
 
What's a pivot table?

Basically, we're trying to document our department's expenses in both weekly and monthly form until we get some training for our database. I don't want to have to input each row of data twice. The data is almost the same for both forms, but the monthly form is much more detailed and there are certain sections where each datum goes; e.g. a belt purchased for a filler would be filed under that filler's entry.

EDIT: whoa, pivot tables look useful
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top