Is this a possiblity?
I am currently tasked with automating a report from data on another spreadsheet. I am manually sorting and filtering data (different sorts and filters applied each time) on one sheet and manually transferring them to a report on another spreadsheet. My question is, can I somehow link the report to reflect the data on my first original data sheet? Note, this original data spreadsheet that I must sort and filter a certain way to gather certain lines of data in my other report changes daily. A new data spreadsheet is uploaded everyday to our company website, and sometimes the data changes. So, is it possible to grab the new daily updated data spreadsheet, and have its specified values automatically fill my report? I hope I gave enough description to this. Thank you for taking the time to read this and I hope I can gain some insight to this.
Yes, this is possible. You
Yes, this is possible.
You can have a macro to do this task.
Can you share the sample file here ? Thanks.
Regards,
DILIPandey
Thank you DILIPandey,
Thank you DILIPandey,
Unfortunately I cannot share the file because it contains company sensitive material. I am not familiar at all with macros but I guess I can do some research and see what I can come up with to solve my problem. Thank you once again.