Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Row to work sheet
I have a excel sheeet with row heading and 10 rows. I want to map the values
of these rows in to 10 separate similar work sheets , where in the each row's values are placed in identical manner. Please let me know how to do this |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Row to work sheet
Hi
Select sheet2 hold down the shift button and select sheet11. This will Group the sheets, and anything you do to the first sheet will be replicated to the others. In cell A1 type = then navigate to cell A1 of Sheet1 and press Enter. You should see =Sheet1!A1 as the cells formula Copy this formula down for 10 rows (and across if you want more than 1 column. Click on Sheet1 tab to ungroup the sheets. Now anything entered in Sheet1 will be replicated to the other sheets. -- Regards Roger Govier "Row to worksheet relation" m wrote in message ... I have a excel sheeet with row heading and 10 rows. I want to map the values of these rows in to 10 separate similar work sheets , where in the each row's values are placed in identical manner. Please let me know how to do this |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Check Activesheet for chart sheet or work sheet | Charts and Charting in Excel | |||
GETTING SELECTED DATA FROM A WORK SHEET TO OTHER WORK SHEET | Excel Discussion (Misc queries) | |||
Populating work sheet combox with another work sheet values | Excel Discussion (Misc queries) | |||
Is there away to keep "auto save" from jumping to the first work sheet in the work book? | New Users to Excel | |||
Spin button in a work sheet - how do I make it work? | Excel Worksheet Functions |