Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying Data from one workbook to another
I am doing Time caps for my company with column A listing the names of the
employees and row 3 is the date. In each other field there is a number of hours worked for each individula employee In the one workbook it is setup on a by-weekly format the current one is for March 24th to April 6th I want to be able to type the information into this workbook and have it also show up in the Monthly workbook that I am also working with. Is there any formula that would let me do this easily without having to copy and paste each selection. I have a thought of what it could look like but I'm not sure how to accomplish it. I.E. have the formula search the by-weekly workbook for a particular date then find each individual employee and enter the corisponding value similar to a times table setup find 3/11/07 across the top then down thr left side find the appropiate name then enter the value. Is this even possible. Please Help not much hair left to pull out. Kelly |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying data from one workbook to another | New Users to Excel | |||
copying data to different worksheets in the same workbook | Excel Worksheet Functions | |||
Copying data from workbook/sheets to another workbook/sheet | Excel Programming | |||
loop through a column on a workbook copying data on each row to another workbook, then copy data back to the original workbook | Excel Programming | |||
copying data from one workbook to another | Excel Discussion (Misc queries) |