Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,986
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Totaling cells from separate worksheets to master form snake941 Excel Discussion (Misc queries) 1 April 22nd 10 01:13 AM
Merge cells from all worksheets into a master worksheet pmv464 Excel Discussion (Misc queries) 2 March 29th 08 11:49 PM
Creating/Naming New Worksheets Based on Select Cells in Master Worksheet Lilbit Excel Worksheet Functions 2 March 19th 08 05:05 PM
Extract values from certain Cells to a Master Worksheet prkhan56 Excel Programming 2 February 15th 05 01:44 PM
how do i link a number of worksheets to one master worksheet? Rusty Excel Worksheet Functions 0 January 24th 05 08:49 AM


All times are GMT +1. The time now is 03:33 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"