Hi! I’m trying to create a macro that pulls a copy of a sheet from a file with a certain date in the file name into a new workbook. Is there a way to do this?

Posting as :
works at
You are currently posting as works at

There's def a way to do this. That said, how would I tackle this:

1- create a macro that outputs all file names in a given location

2 - use a reference formula (e.g., index match) to search for the correct file (tip: use wildcard characters)

3 - create a macro that goes into the "correct file" and outputs all sheet names

4 - create a macro that copies another tab (or values on that tab, depending on what you need) into file master

That's it. This way you have a macro that will auto-update by itself, as long as the file you're looking exists in the folder.

like

I like this idea! Thank you!!!! Works and I think I like it better than the PQ option. Appreciate the help!!!

like

Use power query.

like

Thank you for the ideas! I went another way but I watched a lot of videos on this and I think I can apply to a couple different projects. Thank you again!!!

Related Posts

Fellow fish, looking for a recommendation at PwC . Saw a role I'm really interested in the EUR team at Strategy & London. I'm happy to share my CV and motivation for applying, please DM if you can help. PwC Strategy&

like

What are your thoughts on UK’s economy in the following years? How do you think it will impact daily life?

like

Marriott room smells like an ash tray. How many points?

likefunnyuplifting

How are freelance editors doing right now during this time? Are agencies cutting back on bringing freelancers on board right now? Or are y’all still getting work?

like

Do colleges require SAT scores for fall 2022 admissions? What are the best online resources for college planning? Appreciate your insights and any experiences you can share.

like

Thinking of exiting into Banking / Payments space from USI S&O. Anyone has any leads into places recruiting actively?

like

COMMENTS REQUESTED!

In the past, lawyer wellness and lawyer discipline/character fitness for bar applicants have existed in silos. I’d like to finally form a bridge between lawyer disciple and lawyer wellness and focus on prevention. When we think of lawyer discipline, we automatically think of outrageous behavior like stealing money. Those are extreme. The common cases are too stressed out and forgetting deadlines or death of a loved one and not having time to call clients back. Cont’d

like

Lien search help. I work at a regional firm, and only one paralegal is available. This paralegal started yesterday …. I essentially have to coordinate with the lien search rep to order lien searches. When an entity is incorporated in DE but the PPB is in a different state, what searches need to be conducted and where? Would we need bankruptcy and federal judgments and lawsuits in DE?

I am interviewing for a role, during these crisis times, is it a good time to shift jobs? Is Autodesk doing layoffs, performance based cuts during these difficult times, considering Google, Microsoft, Infosys doing layoffs, hiring freeze, etc..

like

I have been in the electrical / Electronics field with an exp of 6+ yrs. To be honest these fields do not pay as much as their IT counterparts. People in IT discuss on being underpaid at 20LPA whereas ours is not even half of that. I need to know now is that with 6+ years of industry exp. Can I switch my streams for a well paid job. If yes please do help me out. Even otherwise I am open to suggestions and advice.

likefunny

Greetings, Ghosted! bowl members. As 2019 concludes, people who posted here: please let us know if you ever heard back from your ghosters.

like

Trying to pivot into marketing (my original passion) but heard I might have to lower my salary standards. Is it possible to get an entry experienced hire role for 70k+? Or are there any specific/similar roles where this would be more realistic? I live in New York by the way :)

like

Any intel on Akerman billable requirement?

like

Seriously thinking of taking a 6 mo sabbatical and getting away from it all for a while next year. Potentially travel around the world in Q3 / Q4 presuming the pandemic situation has improved. Single and kids are in college so no day to day family responsibilities. Anyone done something similar? Would love to hear your experiences. I know it will set me back from making Partner by at least 1 year but who cares? I feel like it will be a life changing experience (traveling around the world part).

like
like

Diggs or McLaurin? PPR.

like

Do your laptops actually work well? EY laptops break constantly. It hurts my team's ability to get work done. IT replaces them if needed but with crap that breaks again. Normal, EY issue, or just me?

like

Hi, i will be joining a startup soon to work as a product manager. What are some good books/materials/courses I can read in the meantime to prepare myself better for the job?

like

Amazon Launch MBA Program - application has been on active on "read" for 2 months. Original timeline, pre-layoffs, offers out November / December. Does anyone have any contacts within the program? Or anything I can do to inquire?

likesmart

Additional Posts in Excel Genius

I’m trying to go back to the basics. How do you guys structure thoughts around identifying the correlation between 2 variables? A basic example: the number of steps I take in a day and the hours of sleep I got that night.

like

I want to create a heat map of when people are unavailable with day of week as the columns and hour of day as the rows. I have start times and end times, how can I use this data to create the map?

like

What are the most typical models you all build

likehelpful

Last cell question. Some of my simple models are massive in file size because every tab has a last cell of ~XFD65. But I’m not using anything past ~U100. Continued.

like

I have three lists. Each is a list of processes. Each list represents one hierarchy level. Is there an easy way to get from three separate lists to one list ordered like shown on the right?
Thanks for your help fish!

Post Photo
like

Whats a good book/course that will teach me advanced excel skills? I want to be quick with shorcuts etc & learn VBA/Macros. Under $30 please, input is greatly appreciated.

like

Anyone know if / how to have the CapIQ and SNL (MI) excel plugins running at the same time? I always run into issues with one of them not functioning when they’re both enabled

Any recommend courses (coursera, edx, etc.) people would recommend for user with intermediate experience with excel?

like

Why when I refresh a query, the table where the query is loaded to just gets duplicate rows? Same with the pivot table that feeds off of that query?

like

Hey Geniuses! I apologize in advance if this question has been asked before, I'm new here and just trying to learn as much as i can. Does anyone know a great source to learn Macros for beginners. I would like to create one for work. I appreciate it

like

If you follow him on LinkedIn you probably already saw this! Lol 😆 but I totally resonate with the post... 🤣

Post Photo
funnylike

Has anyone encountered this error before? We can’t access a workpaper with 70% of the work done 😩😩

Post Photo
like

How do you all prepare for excel/financial modeling tests? Every firm is different, so I imagine there are multiple effective ways to get ready.

likehelpful

Can anyone help me with this pls? I created a graph using data above (not shown) but for some reason “technology” here appears three times. I want sectors to be grouped together. Is there any way to fix this?

Post Photo
like

What’s the best way to become a good excel modeller in a short time? Coursera course? Something else?

like

How can I extract just the year into a new cell from a “yyyymmdd” cell (labeled PD here) that isn’t recognized as a date? I basically need to sort this data by year. Thanks in advance!

Post Photo
like

Index match question! Is there any way to add a sum function? Index match pulls the first value in the table, but I want the sum of all values in a row with the same header.

like

What macros do y’all have set up?

like

Hello,
Can someone help, please?

If I want to know the percentage of the late orders each person has, what is the formula in excel that does that?

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal