(Solved) – I need help developing an excel macro that can format pre-existing information based on relative cell values

  • by

I have a pretty specific need, I am seeing a lot of similar stuff, but nothing that quite fits what I am trying to do. And I am too much of a layman to piece it together.

When we get new clients they will send us their company finances info. For that reason I cannot include images of the spreadsheet that I need to organize, but I will do my best to explain the issue.

My COO would like to use a macro to separate a single column “G” into two columns “G & H” based on whether or not the dollar amount in column “C” is greater than or less than 7.49. If less than, it stays in “G” if greater than, it gets moved to “H”. Is that possible?

Thanks in advanced for any help.

Leave a Reply

Your email address will not be published. Required fields are marked *