VBA Excell book final adjustments.
Budget: $30 – $250 NZD
I need an experienced "Mac" user with expert knowledge of "VBA" for excel. I only need a few completion fix's on an existing Excell Book.
On this book there are 10 different sheets as mentioned below as applicable. I want the two graphs replaced with one pie chart and one bar graph with selectable date range and balance of payments indicator across the sheet.
1: On the Tcode tab where it asks for the new Tcode , I need to have a "text copy" of the full transaction string from the "Data, Tab" that it is referencing.
2: On the "main" tab, I what to list each source file accessed, along with its path i.e. C:/Documents/File.
Plus, two question placed on the "Main" sheet. "Postcode" and "How many rooms does your home have".
3: Reset Button, reset all data (clean Sheet) including charts, while leaving Tcodes and Tstrings in unchanged.
4: I need a pie chart that lets you drill down into the data. First ring, profit and loss (with $ values) next ring, contained Tcodes, the 100's, then 10;s. Plus, a definable date range. Can a chart only like that used in https://nektony.com/help/disk-space-analyzer work for task with selectable Tcodes.
5: The "Export _Transactions" need to be presented like a pivot table based on each Tcode having its own column.
Aswell as the Tcode's labeled by both, word, row one and Tcode number, in row two., "Postcode" row three, and "Number of Rooms" in row four.
Finley delete the "C/D" column.
On this book there are 10 different sheets as mentioned below as applicable. I want the two graphs replaced with one pie chart and one bar graph with selectable date range and balance of payments indicator across the sheet.
1: On the Tcode tab where it asks for the new Tcode , I need to have a "text copy" of the full transaction string from the "Data, Tab" that it is referencing.
2: On the "main" tab, I what to list each source file accessed, along with its path i.e. C:/Documents/File.
Plus, two question placed on the "Main" sheet. "Postcode" and "How many rooms does your home have".
3: Reset Button, reset all data (clean Sheet) including charts, while leaving Tcodes and Tstrings in unchanged.
4: I need a pie chart that lets you drill down into the data. First ring, profit and loss (with $ values) next ring, contained Tcodes, the 100's, then 10;s. Plus, a definable date range. Can a chart only like that used in https://nektony.com/help/disk-space-analyzer work for task with selectable Tcodes.
5: The "Export _Transactions" need to be presented like a pivot table based on each Tcode having its own column.
Aswell as the Tcode's labeled by both, word, row one and Tcode number, in row two., "Postcode" row three, and "Number of Rooms" in row four.
Finley delete the "C/D" column.