Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Macro To put data from one sheet to another
I have a workbook which has about 10 pages. Is there a macro or way I can
link certain cells? I want to enter info. in cell A1 on first worksheet and have it come up in cell b1 on sheet two and cell d3 on page 3. Or something like that. |
#2
|
|||
|
|||
mower man, try this in sheet 2 and 3 =Sheet1!A1
-- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "mower man" wrote in message ... I have a workbook which has about 10 pages. Is there a macro or way I can link certain cells? I want to enter info. in cell A1 on first worksheet and have it come up in cell b1 on sheet two and cell d3 on page 3. Or something like that. |
#3
|
|||
|
|||
I have multiple worksheets and wish to use data from a cell in one worksheet in a formula in a different worksheet..ie take data from A WORKSHEET TITLED GRAND TOTAL FOR B-SHIFT INTO A FORMULA in R17 for use a different worksheet in CELL B4 (in a formual to determine # of computer epaired per hour automatically by the data entered into the worksheet titled GRAND TOTAL FOR B-SHIFT). am using vb command buttons to calculate figures per hour and have the results appear in a cell b4 to b 15, using a number of different command buttons; one for each hour) tks ratt out -- ratt ------------------------------------------------------------------------ ratt's Profile: http://www.excelforum.com/member.php...o&userid=24318 View this thread: http://www.excelforum.com/showthread...hreadid=396000 |
#4
|
|||
|
|||
this worked very well -- thank you -- i played with it about 5 minutes and
realized i had to substitute the sheet name -- thanks again "mower man" wrote: I have a workbook which has about 10 pages. Is there a macro or way I can link certain cells? I want to enter info. in cell A1 on first worksheet and have it come up in cell b1 on sheet two and cell d3 on page 3. Or something like that. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro data selection line delete | Excel Discussion (Misc queries) | |||
Append the data given in diff sheets of an Excel File to one sheet | Excel Worksheet Functions | |||
Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) | |||
Function to automatically insert a new sheet as a result of data entry? | Excel Worksheet Functions | |||
Daily Macro to Download Data, Order and paste in order | Excel Worksheet Functions |