Hello Everyone,
This is my first post regarding VBA Macros so bear with me!
The last couple of weeks ive been developing a macro but ive hit a snag and i think its probably very simple to resolve but after hours of forum browsing, ive come out more stuck than before. Heres what im trying to achieve:
Im trying to insert an entire row above two cells in two seperate columns that have a combination of numbers for example:
If Cells in Column G=0 and Cells in Column H=1, Then insert row above those cells. The Data in my excel sheet are as below:
Column G Column H
1 0 0
2 0 1
3 0 2
4 0 3
and i basically want to insert a row above Row 2 where G=0 and H=1.
The reason i want to Macro this is because im going to duplicate the macro for various other combinations such as G=1 + H=1, G=2 + H=1 and so on..
Any help would be much appreciated.
Bookmarks