Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying Data from a row above...
I have a very complex and large spreadsheet that I am trying to edit. Through
several different steps and macros we have things pretty close to where we need them with one exception. We need to do a search (in this example - on column 3) and if the results of the search are a blank space, we want to copy the data from column 4 in the ROW ABOVE and paste it into the blank cell in column 3. Ultimately we would love to copy all of the rest of the data and put it in the same row. The only difference from the two rows is that we would have copied the contents of one cell twice - to the 3th column and the 4th column. Everything else would just drop down to the next row... It is hard to describe, so I have created a "before and after" view of what we are trying to acomplish... BEFO Row 1 IBM Ipaq Family Model 11 Model AA Product XL K9a478 Row 2 IBM Ipaq Family Model 55 Model GG Product SD UUa771 Row 3 Row 4 HPC Ipaq Family Model 49 Model FF Product TR JHa888 Row 5 Row 6 KFC Ipaq Family Model 61 Model TT Product VZ JHa546 AFTER: Row 1 IBM Ipaq Family Model 11 Model AA Product XL K9a478 Row 2 IBM Ipaq Family Model 55 Model GG Product SD UUa771 Row 3 IBM Ipaq Family Model GG Model GG Product SD UUa771 Row 4 HPC Ipaq Family Model 49 Model FF Product TR JHa888 Row 5 HPC Ipaq Family Model FF Model FF Product TR JHa888 Row 6 KFC Ipaq Family Model 61 Model TT Product VZ JHa546 THANKS FOR YOUR HELP!!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying rows of data into new worksheet but placing data into colu | Excel Discussion (Misc queries) | |||
Comparing data between sheets, and copying rows with data | Excel Programming | |||
Copying data as static as source data changes | Excel Worksheet Functions | |||
Copying Data into Column with Existing Data | Excel Discussion (Misc queries) | |||
Copying data down to next dirty cell, then copying that data | Excel Programming |