|Hi Excel masters,|
I hope someone can help me with this:
I need to get data from an online report (which can be exported as Spreadsheet) automatically filled in an excel sheet (in another template).
The tricky part is that information in the online report can change with additional row/column for additional items purchased.
How can I create additional row/column in my excel sheet and get all data to be filled in (copied) from that online report automatically whenever there is any additional items appear in that report?
In Online Report, there are following items:
But in our Excel template, there are only these items:
How do I automatically add a row in my Excel template for Glasses and other items that could be updated in the future? (i.e. whenever there is any additional information in the report downloaded online, that piece of information can be added in our excel template.
Hope you can help me with this, pleaseee :)