Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pasting to calculated address
I have a workbook with 2 worksheets. The first worksheet has names and hours
for a single day. The second worksheet contains the sames names but data for each day of the year, names in one row and dates in one column. At the end of the day I need to post the daily hours for each person to the yearly worksheet. I have done the lookups and matches to calculate the row number and the column number of where the data needs to go. I just don't know how to tell the macro to copy the hours from the daily and paste it in the address in the yearly. Daily 9/18/09 Joe 4.5 Eric 1.75 Betty 1.0 Sue 3.25 Yearly Betty Eric Joe Sue 9/15 3 1 2.25 1.75 9/16 1 1.75 3.5 6 9/17 2 1.25 4.5 3.25 9/18 9/19 Total 6 4 10.25 11 ;Sum() The row in yearly is the same for all names. The name is returned as a column number. The target address is in the form 'Yearly'!$B$176 Can anyone help me with this? Thanks in advance... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pasting to calculated address
I forgot to say that I am using Excel 2007.
"Jerry" wrote: I have a workbook with 2 worksheets. The first worksheet has names and hours for a single day. The second worksheet contains the sames names but data for each day of the year, names in one row and dates in one column. At the end of the day I need to post the daily hours for each person to the yearly worksheet. I have done the lookups and matches to calculate the row number and the column number of where the data needs to go. I just don't know how to tell the macro to copy the hours from the daily and paste it in the address in the yearly. Daily 9/18/09 Joe 4.5 Eric 1.75 Betty 1.0 Sue 3.25 Yearly Betty Eric Joe Sue 9/15 3 1 2.25 1.75 9/16 1 1.75 3.5 6 9/17 2 1.25 4.5 3.25 9/18 9/19 Total 6 4 10.25 11 ;Sum() The row in yearly is the same for all names. The name is returned as a column number. The target address is in the form 'Yearly'!$B$176 Can anyone help me with this? Thanks in advance... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want to create a calculated item based on a calculated field | Excel Discussion (Misc queries) | |||
Problem with Calculated Items on Calculated Fields. | Excel Worksheet Functions | |||
Calculated Field and Calculated Item in Pivot Table | Excel Discussion (Misc queries) | |||
PivotTable:Using a calculated field result in another calculated f | Excel Worksheet Functions | |||
pivot table formulas for calculated field or calculated item | Excel Discussion (Misc queries) |