In an attempt to make this more automated for the user, I have run into a road block.
The goal is to populate the cells in columns AA, AB, AC with data from D, E and F. However, I only want this function IF B has a value greater than 0.
If that value in B is =0, then I do not want anything copied.
I have tried to write this with the "IF" function, but can't fill in AA, AB, AC with out blank rows in the place of the skipped over (or unwanted) data.
The Values for D, E, and F are linked from another workbook and currently the user has to copy and paste the values themselves. This is error prone when doing 20 or 30 entries in a day.
I have attached a worksheet that contains what I WANT the RESULT to LOOK like.
Bookmarks