| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I automatically get information from sheet 1 into sheet 2
Information on sheet 1 is in columns with 24 rows, i.e. B1:B24, B26:B50 and
so on. Sheet 2 is in rows of 24 columns with names corresponding to the columns on sheet 1 i.e. A2:W2 Then B2:X2. I can get the data if I manually select each cell on sheet 2 & =Sheet1!B2 & so on. Is there a formula to accomplish this as each set of imported data to the rows on sheet 2 are 24 row numbers apart. (sheet 2 b4 = sheet 1 c50 & sheet 2 b5 = sheet 1 b74). Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for automatically entering information from a master sheet | Excel Discussion (Misc queries) | |||
| create a formula in one sheet that would read data from separate sheet automatically | Excel Discussion (Misc queries) | |||
| can entered data in sheet 1 be automatically pasted in sheet 2 | Excel Discussion (Misc queries) | |||
| Extracting information from records to another sheet automatically | Excel Worksheet Functions | |||
| Extracting information from records to another sheet automatically | Excel Worksheet Functions | |||
Threaded Mode
