-
.
Because the cell references are always the same ( J2 to K2, J3 to K3, etc.) why not use a formula in the cells that will be receiving the data (K2, K3, etc)
In K2 type =IF(J2="","",J2) and press ENTER.
In K3 type =IF(J3="","",J3) and press ENTER.
Do the same for all of the remaining cells.
What the formula is saying : IF cell J3 is empty, then K3 won't display anything. But if J3 does have data it will be displayed in K3.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules