it has been quite a few years since I wrote if/then formulas. I am looking for help to write an if/then statement to move a row down under another header on the same sheet once a value is entered. The value would be a closed date less than todays date.
Thank you for your help.
Nicole H.
you might have to be more clear, formulas don't "move" things, that would be VBA. I'm having difficulty understanding your request.
could you mock up an example sheet with what you have and what you expect the results to be? It wouldn't have to be much, just enough for us to understand what you are dealing with and what you want. Go advanced to upload a workbook. Mid way down is a blue hypertext "manage attachments" and click that and follow the prompts to upload a workbook.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Thank you for your help. Sorry for the confusion.
I would like to learn how to move data from a row to another row in another section of the page once an "effective date" is entered into cell "O".
an example would be
Move (Buyers) A5-Q5 to (Closed Buyers) A53-Q53 once an effective date was entered into "O5". and each concurring entry gets moved to the next available line.
Move (Sellers) A18-Q18 to (Closed Sellers) A53-Q53 once effective date is entered into cell "O18". and each concurring entry gets moved to the next available line.
Is this possible?
Thank you
Nicole H.
The best (without VBA) based on what you wrote and what you attached is that you could put this formula in cell A18 and dragged to the right and down.
=IF($O5<>"",A5,"")
this means that you can only input data into the first "buyers" table in A5 through D13 (or wherever you want to pull down the data from) but if you input anything in A18 other than that formula you will over write the formula. You can also use that in M18, N18 and O18 and drag down too. If this is not what you want then you need to better explain and you might need VBA.
This did what I needed but I see it can become cumbersome to keep it updated and formulas straight.
Would VBA be able to mimic this formula in the respected sections?
I just need the data in (Closed Buyers) A53-Q53 to be populated when the "effective date" is entered into "O5". each concurring entry is moved to the next available row.
and (Closed Sellers) A53-Q53 to be populated when the "effective date" is entered into "O18". and each concurring entry gets moved to the next available row.
my end goal is to move "closed" contracts to the "Closed Buyers or Closed Sellers" automatically.
there shouldn't be anything "cumbersome" about it. It is just dragged to the right and down by grabbing the little box at the bottom right of the cell where it is.
But to do it automatically without the use of formulas in cells you do need VBA and I don't have those skills.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks