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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying Data from one workbook to another
The general form of a referenced cell is a follows
'[c:\my workbook.xls]My worksheet'!A1:B7 Note that the single quotes are needed only if there arre spaces in the workbook name or the worksheet name. "madduck" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying Data from one workbook to another
This function did not work or I'm not doing it right any other suggestions?
"Joel" wrote: The general form of a referenced cell is a follows '[c:\my workbook.xls]My worksheet'!A1:B7 Note that the single quotes are needed only if there arre spaces in the workbook name or the worksheet name. "madduck" wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying Data from one workbook to another
This isn't a function it is a way of referencing a cell in another workbook.
It is part of a function. On the same worksheet you would use =A1 or =sum(A1:A4) on a different worksheet in the same workbook ='sheet2'!A1 or =sum('sheet2'!A1:A4) to a different workbook ='[workbook2.xls]sheet2'!A1 or =sum('[workbook2.xls]sheet2'!A1:A4) "madduck" wrote: This function did not work or I'm not doing it right any other suggestions? "Joel" wrote: The general form of a referenced cell is a follows '[c:\my workbook.xls]My worksheet'!A1:B7 Note that the single quotes are needed only if there arre spaces in the workbook name or the worksheet name. "madduck" wrote: 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 |
Reply |
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) |