Browse window: Importing data onto a new line in another spreadsheet

Hi there,

We run multiple projects and have trackers for our budgets. All of this information is visible on a summary page.

My manager would like to be able to import some of the values on these summary sheets into a master sheet, putting the vital stats from each project on a new line.

Can I add a 'Browse' button where he could click it, navigate to the new project's tracker and it would automatically import the vital stats from that tracker on the next available line?

I've attached an example summary tracker sheet, plus an example of the master sheet that my manager would want to import the data into. I've noted on the master for my manager which cells from the summary tracker I would want the data for.

I can see this being a one-step process for my manager, he simply selects the new project file and it imports all the info he needs! All projects will use the same template so the summary page will not change.

Sorry if this sounds confusing, happy to confirm things if there are any questions.

PS - I'm not well versed in VBA yet so if the solution uses it, a help on how to get started on it would be great.

Thanks!

Summary Tracker Example.xlsxManagers Master EXAMPLE.xlsx

Hi Jaslake,

Thanks for picking this up!

The projects will be in different folders eg "C:/Finance/Project 1/project1file.xls" and "C:/Finance/Project 2/project2file.xls". The names of the project folders will not be consistent, nor will the names of the files.

The good news is that the data required will always be on the first tab, named "Summary"

Hope this helps :o)

Jenny

A path like that, yes.

Thanks!

Oh my god this is AMAZING!!! Thank you soooo much - it does exacly what I wanted... Maybe someday I'll know as much as you!

Hi Jaslake,

I'm enjoying implementing your handy button. However I'm having some difficulty adapting it for another sheet.

I have attached my spreadsheet. It works perfectly on the 'Operational' sheet, but I now need the button on the 'Final' sheetto bring the same data onto that sheet - I'm sure this is a super-quick thing for you, I've been trying it for hours and just can't find a way to duplicate and amend the code.

Can you help me?

Thanks,
Jenny

Final Quote Model Analysis (Autosaved).xlsm

Hi Jaslake,

Thank you so much for your promt reply! I am finding it comes up with a Runtime error '76' Path not found when I hit the Browse Button. And the debugger is highlighting the 'ChDir MyDir' line. I'm sorry I can't remember what to do what that bit. In the previous code I might have taken it out as it isn't present. When I take it out of this version it just opens the file rather than gathering the info stored in it?

I do not need to direct the user to a set file location, so just 'My Computer' would be fine.

Apologies, for bothering you!

That worked perfectly! In my wildest dream I wish I could understand why that made a difference, but as my brain's already about to pop I may leave that for another day! Thanks, I'll mark this as Solved again ;o)

Hi Jaslake,

The code you gave me has been working perfectly, however I recently made a change to add in an extra column (I added it to the last line), and now the code seems to be going to seek the information, but not bringing anything back.

Have I done something wrong?

I've attached the sheet with the code - 'Final Project Analysis' (see Operational and Final tabs for the button. The action should then import the data on the Summary tab of the 'Cost Tracker' file, but it isn't doing.

Sorry to be a pain...
Jenny