Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
fill data
I have two worksheets (wkst 1, wkst 2). They are in different files. I was
wanting to fill down the data in a column on wkst 1. The data is being pulled from a row in wkst 2. As it is, if I fill down the column formula in wkst 1, it fills the data in wkst 2 but from a column as well, and I am wanting it to pull from the row in wkst 2 rather than the column. Can anyone help? Is this possible? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
fill data
Perhaps try copying the applicable data in the row, selecting the cell in
wkst 2 where you want the data to begin and then going to EditPaste Special and choose the Transpose checkbox. In my experience I have not found a way to get a horizontal data lay out to fill vertically. I either use paste special options or a macro. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Fill | Excel Discussion (Misc queries) | |||
Filter data and fill only filtered data | Excel Discussion (Misc queries) | |||
fill data | Excel Discussion (Misc queries) | |||
Fill in data if | Excel Discussion (Misc queries) | |||
I have a list of data, fill in the gaps. FILL function won't work | Excel Discussion (Misc queries) |