| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Automatic cell increment with data from sheet 1 to sheet 2
I want to create a secondary excel sheet that combines information from a
primary sheet. The primary sheet contains an extract of data from Pastel which is an asortment of data in rows and columns. However, the data is repeated at regular intervals. Eg. Cell B4, B17, B30 contain same data for different clients. I want a formula that I can drag and drop which increases the cell reference from =sheet1!B4 to =sheet1!B17, to =sheet1!B30 etc. Sheet 2 will have all data in columns, the first row of which I have copied across to sheet 2 as =B4; =B5; =A7;=D4; etc. Hope this makes sense. HELP -- GJC |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| List, Data Validation, unlocked cell, protected sheet..... | New Users to Excel | |||
| pull data from sheet two, then fill in the data to sheet one (part | Excel Worksheet Functions | |||
| How do I input for an automatic increment in a cell on Excel? | Excel Worksheet Functions | |||
| Function to automatically insert a new sheet as a result of data entry? | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
