Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
link cells in master worksheet to other cells in other worksheets
master worksheet named 'details' with cells containing all the
required data other worksheets named such as e.g. 1000, 1001, 1002 etc in the same workbook need to insert the required data in master worksheet 'details' cells into the other worksheets' cells |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
link cells in master worksheet to other cells in other worksheets
You will need to be a little more specific about your requirements. Things
like the rows or columns where the data is on "details" and where it is to go on the sheets 1000,1001, etc. " wrote: master worksheet named 'details' with cells containing all the required data other worksheets named such as e.g. 1000, 1001, 1002 etc in the same workbook need to insert the required data in master worksheet 'details' cells into the other worksheets' cells |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
link cells in master worksheet to other cells in other worksheets
On May 15, 5:16 am, JLGWhiz wrote:
You will need to be a little more specific about your requirements. Things like the rows or columns where the data is on "details" and where it is to go on the sheets 1000,1001, etc. " wrote: master worksheet named 'details' with cells containing all the required data other worksheets named such as e.g. 1000, 1001, 1002 etc in the same workbook need to insert the required data in master worksheet 'details' cells into the other worksheets' cells ok hope this is clearer: the column A cells in the 'Details' master worksheet would have data like 'serial#' link/insert the data in cell A2 in the master worksheet to the cell C3 in the 1001 worksheet . . . link/insert the data in cell A3 in the master worksheet to the cell C3 in the 1002 worksheet . . . link/insert the data in cell A4 in the master worksheet to the cell C3 in the 1003 worksheet . . . and so on and so on . . . TIA . . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Totaling cells from separate worksheets to master form | Excel Discussion (Misc queries) | |||
Merge cells from all worksheets into a master worksheet | Excel Discussion (Misc queries) | |||
Creating/Naming New Worksheets Based on Select Cells in Master Worksheet | Excel Worksheet Functions | |||
Extract values from certain Cells to a Master Worksheet | Excel Programming | |||
how do i link a number of worksheets to one master worksheet? | Excel Worksheet Functions |