Excel Macro
Budget: $10 – $20 USD
I have an excel file with around 8 columns.
1.-I need to automatically create a new column that says: Contract number.
2.- Go though the property name and the owner name and group the same properties into the same contract number.
3.- If the owner names are the same in more then one property, then group them together under the same original contract number.
I have an example of the original file and the say it should look once the macro runs.
1.-I need to automatically create a new column that says: Contract number.
2.- Go though the property name and the owner name and group the same properties into the same contract number.
3.- If the owner names are the same in more then one property, then group them together under the same original contract number.
I have an example of the original file and the say it should look once the macro runs.