Greetings my dear learned friends,
in the screengrab below I need to determine if cells in Col B is a number. If it is a number, move cells in col B:AS to J74.
Then check the next row, B76. Because B76 is text, skip to B77.
B77 is a number Move B77:AS77 to J76.
Loop through 2500 rows.
Please help me with this I have no idea how to solve this.
in the screengrab below I need to determine if cells in Col B is a number. If it is a number, move cells in col B:AS to J74.
Then check the next row, B76. Because B76 is text, skip to B77.
B77 is a number Move B77:AS77 to J76.
Loop through 2500 rows.
Please help me with this I have no idea how to solve this.