How to Insert Row and Copy Data Automatically Based on Input

October 3, 2016 at 07:22:04
Specs: Windows 64
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?
For example:
In Online Report, there are following items:
Shoes
Clothes
Glasses

But in our Excel template, there are only these items:
Shoes
Clothes

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 :)


See More: How to Insert Row and Copy Data Automatically Based on Input

Reply ↓  Report •

Related Solutions


Ask Question