| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If Cell Contents Don't Match, Move All Data Down One Row
Hello,
I am a newbie to VBA and am trying to write a simple script which will compare to cells (I1 & J1 ro example) and if they do not match then I need to grab the contents of the sheet (starting at that row) and move cell ranges A thru I down one row. If they match, then I just need to move my cursor down to the next cell (I2) and start the copmparison again against J2. Essentially I am trying to line up all contents with its respective row. I am sure someone has had to do this before and maybe someone could help me get started or point me in the right direction |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Move cell contents with macro | Excel Discussion (Misc queries) | |||
| how to move contents in column up one cell | Excel Worksheet Functions | |||
| move cell contents | Excel Discussion (Misc queries) | |||
| Macro to remove contents of cell and move all other contents up one row | Excel Discussion (Misc queries) | |||
| How to move cell contents | Excel Discussion (Misc queries) | |||
Threaded Mode
