| 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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to link data from one source sheet to multiple sheets
Hi,
You will need to automate this with VBA: For example, if your data starts on row 2 and goes to row 29 on Sheet1 and the titles are in cells A1:C1, then something like this will work. You can enhance the flexibility by having the code determine how many rows but that depends on you data layout - are there missing items in some cells, are there totals at the bottom of columns, is there other data below the data... Sub CopyData() For I = 2 To 21 Sheets.Add Range("C5:E5") = Sheets("sheet1").Range("A" & I & ":C" & I).Value Next I End Sub -- Cheers, Shane Devenshire "Ashish Deshmukh" wrote: 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to link data from one source sheet to multiple sheets
Hello Shane, Thank you very much.
I do not VB but I will try this and get back to you again. Once again thanks. "ShaneDevenshire" wrote: Hi, You will need to automate this with VBA: For example, if your data starts on row 2 and goes to row 29 on Sheet1 and the titles are in cells A1:C1, then something like this will work. You can enhance the flexibility by having the code determine how many rows but that depends on you data layout - are there missing items in some cells, are there totals at the bottom of columns, is there other data below the data... Sub CopyData() For I = 2 To 21 Sheets.Add Range("C5:E5") = Sheets("sheet1").Range("A" & I & ":C" & I).Value Next I End Sub -- Cheers, Shane Devenshire "Ashish Deshmukh" wrote: 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. |
| Reply |
| 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 | |||
Hybrid Mode
