I needed to lookup values in my 'sales trend.xlsx' file for month wise sales value depending on sales office code, Material group name. But the range is not defined to particular workbook name. Data is divided in 11 sheets named 'Z1.xls' to 'Z11.xls'.
Here is a similar kind of question.
https://www.excelforum.com/excel-gen...ple-files.html
Last edited by abhinavbinkar; 07-05-2020 at 01:44 PM. Reason: Link for similar question
bump
Please help.
Last edited by abhinavbinkar; 07-02-2020 at 02:45 PM.
bump
Help needed.
Is it possible?
Waiting for help.
121 views of the thread, only 1 view of the attachments and no help offered. There are two possible reasons:
1. Your request isn't clear enough.
2. You are expecting too much.
If the former, add more detail. If the latter, consider paying someone to build a solution for you in Commercial Services.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks