I'm new to using if then statements, but I think that is what I need to
accomplish this task. Here is my situation. I download a report everyday
that has thousands of rows and the row count changes each day. In an
unknown number of rows, column G is empty and the data I need to move into
Column G is in Column K. So I guess what I need is something that would say
If in any row G is empty and if there is data in that row in column K, move
that data in column K to column G. Is this even possible? Thanks so much.
I plan on putting this code in Macro1 with my page setup code. Thank you