Excel automation
Budget: $30 – $250 AUD
I input share investment data from different CSV's. I currently do index matches to construct different spreadsheets, but want to automate so if I have one column of data, it automatically populates to other columns in another tab or sheet.
Formulas to populate columns of data into other spreadsheets and tabs. It is for share investment data, so can be matched up with a share code.
Count instances of cell text between dates and populate the data into other columns in separate sheets.
Would have to show you in person (Richmond, Melbourne) and then you can do at home.
An index match with multiple arrays.
Formulas to populate columns of data into other spreadsheets and tabs. It is for share investment data, so can be matched up with a share code.
Count instances of cell text between dates and populate the data into other columns in separate sheets.
Would have to show you in person (Richmond, Melbourne) and then you can do at home.
An index match with multiple arrays.