| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to link data from one source sheet to multiple sheets
I have data in 1st Sheet with column labels: Account No, Name & Amount. It
consisits of data of 20 rows for 20 different accounts. I want to generate 20 worksheets in the same file each of which will pick the data from sheet 1. Each new generated sheet will pick the data from sheet 1 to a specified cell. (means i would like to have account no of row 1 at C-5 of new sheet, account no of row 2 at C-5 of other new sheet. Can anybody please suggest can it be automated? Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Sheet populating to multiple sheets | Excel Worksheet Functions | |||
| Auto link rows of information from multiple sheets to single sheet | Excel Discussion (Misc queries) | |||
| Multiple sheets as data for a single sheet | Excel Worksheet Functions | |||
| Copy tabs(sheets) from workbook without link to original source | Excel Discussion (Misc queries) | |||
| Copy tabs(sheets) from workbook without link to original source | Links and Linking in Excel | |||
Threaded Mode
