| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copying formula for horizontal data to vertical in different sheet
I have raw data that is horizontal in a worksheet. I need to pull it into a
report, and it needs to be vertical. For example, data is in A1, B1, C1, D1, E1 ..... In my report sheet I enter ='Raw Data'!A1. I then try to copy my formula vertically but it copies vertically from my data sheet. When I make the row absolute by adding $ it still copies vertically even though I leave the column as relative. I have a lot of data and it takes too long to do one at a time. Any help would be appreciated. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| moving data from vertical to horizontal possition | Excel Worksheet Functions | |||
| Need lookup of data both vertical and horizontal | Excel Discussion (Misc queries) | |||
| how to copy a cell with formula from sheet 1 (data is all vertical) into sheet 2 | Excel Worksheet Functions | |||
| How to make Horizontal data go Vertical | Excel Worksheet Functions | |||
| tranfere vertical data to horizontal tabel | Excel Worksheet Functions | |||
Threaded Mode
