the current formula ='[OH_20170718.XLS]01'!G23.
What i NEED is the section OH_20170718 to be pulled from a fix cell in the file
where the data can be located.
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Using and external file
0
Answers
0
Selected Answer
Hmmm....I may be able to assist but can you provide a sample file WITH the results you expect?
Discussion
yes but i am i totally new to this group and i do not know how too
ping me at [EDIT]@gmail.com and will send you the file
ping me at [EDIT]@gmail.com and will send you the file
anhirst (rep: 2) Jul 19, '17 at 10:25 am
no can do on sending file.
queue (rep: 467) Jul 19, '17 at 10:29 am
Whoa anhirst, BAD idea to post your email publicly on the internet, spammers will find that and you will not like the result - I removed it for you.
If you read the rules or help section of the forum, both of which are linked to at the top of all pages in the forum, you would know how to do everything. To include a sample file, edit your question and upload the file there and we will get a notification that you did that.
If you read the rules or help section of the forum, both of which are linked to at the top of all pages in the forum, you would know how to do everything. To include a sample file, edit your question and upload the file there and we will get a notification that you did that.
don (rep: 1989) Jul 20, '17 at 7:28 am