| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying and shifting filtered data by one row & maintaining the da
I have a column of numbers which contain blank rows in between the numbers.
The blanks are in no partcular interval meaning there can be 2 blanks, 3 blanks or 10 blanks or greater between numbers. What I am trying to do is to filter the data by numbers only (done) & copy these numbers & paste it into another column within the same sheet by shifting the entire data by one row up. The pasted columns should look exactly like the filtered column except that the pasted column will start one row up & there will be a blank on the last row. is this possible within the tools available in excel or do I need to write VBA code for it? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copying filtered data in Excel 2007 | Excel Discussion (Misc queries) | |||
| Copying Filtered Data in Excel 2007 | Excel Worksheet Functions | |||
| Copying filtered data to another worksheet | Excel Worksheet Functions | |||
| Trasnsposing or copying filtered data from one sheet to another | Excel Worksheet Functions | |||
| Copying Filtered Data | Excel Discussion (Misc queries) | |||
Threaded Mode
