Dear All,
I was reading about macros and was wondering can i create a Macro for fetching Data in my Template file from an excel file, which i have to generate daily in evening.
By doing so i will not have to copy paste column by column in my template , which i use to make reports.
i have attached two sheets
1) export sheet : which i need to export from my Company software, whose data i have to put in my template sheet.
2) Template Sheet : in MTD Base Sheet i copy paste data in Yellow colour headers and then make Pivot to create different reports. I use Vlookups with help of master sheet in Template.
For more Clarity In export sheet i have clearly made the table showing "from-To" column list.
According to billings, data quantity i.e., no of rows differ every time, in export sheet.
Thanks in advance
Bookmarks