I need a formula to take an entry from one sheet and put into another sheet.
This sheet is just in the construction stage so please forgive my designing.
I need a formula that states
if "Input sheet" B7 is not null then put the amount in "List" sheet on the next empty line.
I have a macro already to tell me what the next empty cell will be in B1 of Input sheet.
But, then the next one in B8 needs to go into "List" C8. So, I think I need an offset formula for this one.
I'm sure there is a more elabrate way of doing this, I just don't have the knowledge.
Bookmarks