| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup and Move Data Function Help
You could do this with a macro which starts in cell A1 and if the cell
is empty then the cell is deleted so that B1 and F1 become A1 and E1. If the cell is not empty then move to B1 and apply the same comparison and deletion of empty cells until the cell is not empty. Then drop down to row 2 column A and repeat the process. Hope this helps. Pete |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| miricle lookup formula??? | Excel Worksheet Functions | |||
| Look up Data from Worksheet within same Workbook | Excel Discussion (Misc queries) | |||
| Look up Data from Worksheet within same Workbook | New Users to Excel | |||
| Sumproduct Formula | Excel Worksheet Functions | |||
| lookup and transfer data | Excel Discussion (Misc queries) | |||
Threaded Mode
