| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
populating new cell with first populated cell to the left
I'm trying to clean up .pdf data that was exported to Excel. The columns are
a mess so I'm working left to right. I was hoping to create a macro that would pick up the first populated cell to the left. It is not always in the same column but when I run the macro, it always goes to the same column. Is there a way to say "+, ctrl left arrow, enter" and have it repeat everytime hit the hotkey assigned? Or... Does anyone know a better way to clean up a worksheet? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| First populated cell in row array/ Last populated cell in row arra | Excel Worksheet Functions | |||
| auto populating a cell based on another cell for an invoice | Excel Discussion (Misc queries) | |||
| Populate cell is another cell is populated | Excel Discussion (Misc queries) | |||
| formula for a cell which is blank returns populated cell | Excel Discussion (Misc queries) | |||
| Populating Last Saved Date in Cell AND also update that same cell in Header | Excel Discussion (Misc queries) | |||
Linear Mode
