Hi Guys. I've been working for a very long while on a way to automatically filter a report using VBA.
Problem is, I don't know VBA at all, and I use the a recorded Macro, the problem is, the recorded Macro looks on Column References and no Column names, the same for Rows, so if the colon order is changed or the number of ROWS / Columns changes, I have to re-record the Macro every time - which isn't a solution.
This is not going to be simple so I thank in advance for everyone who will take the time to help me!
The RAW report I get is an output from RVTools which gives out A LOT of columns (but as we sometimes add or remove custom annotations, the number of columns may change)
What I need the script to do, is to open a new excel file with the name Filtered.xlsx and save it under \\network\path
then from the same location, open an existing file called raw.xls
Then, from RAW file, copy only the following columns:
VM, Powerstate, CPUs, Memory, Provisioned MB, In Use MB and OS into the Filtered File, but only copy the rows where the Clientname is 'Webox'
Then, Rename the Memory, Provisioned MB and In Use MB columns to RAM. Provisioned GB and Used GB respectively and divide the values of said columns by 1024. and then format it as a Table (Style Medium 9)