If a target provides each monthly income statement in a separate excel file, what is the most efficient way to combine the them into one excel workbook (but not one sheet)? I know VBA can do this and I thought power query could do this but couldn’t figure it out. Any suggestions?

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

Alteryx

like

I wish, my firm doesn’t have it.

Related Posts

I'm a masochist. PRQ tied up a ton of my assets during the last run up in early 2021 while crabbing and dumped just as bad as other alts in May. I just heard whispers of a big cex listing and put some money back into it. 😬

like

Recently received 30k and wondering what to do with it. Not yet a homeowner but also not sure if we’re ready to buy anyways. Have a young baby. Any advice on how to figure out best use?

Lease on my current vehicle ends in a few weeks. Do you think auto prices will drop and financing will become free in the next little while?

Should I hold off and Uber around until the drop?

like

What % of your salary was your most recent car purchase?

like

Have 350k in cash, have unfortunately been super conservative or rather I would say silly holding money in the bank all this while. What would be a reasonable strategy to invest this money?

likesmart

where is the best place to sell or trade in my used car? (2019 van low km’s)

like

I’m not bad with money but definitely lots of room to improve overall, due to several personal factors I don’t want to list in full here (numerous unanticipated medical bills, bad boyfriends, etc.) Hence why I only have $3k in savings right now. My first mini goal is to have $5k saved by the end of December. I need motivation and words of encouragement. If I pay off my medical bills, I won’t make my goal. I have to start putting saving money first. Getting depressed about my situation.

like

what you buying?

like

Does anyone use quickbooks to calculate their annual P&Ls and other tax stuff? Do you find it’s better than just an excel template?Any other programs people like?

like

Hi All,
One of my friends has recently joined capgemini and has following doubts related to tax proof.
Can we edit the tax declarations in HGS portal every month any day?
Does Capgemini asks for rent agreement along with rent receipts as a part of tax proof submission?
Also which proofs needed for,
80c - elss lic
80d - insurance for senior citizen parents
80ccd1b - nps

Any Deloitte people trade on robin hood?

like

Newly minted consultant here looking for financial advice.

So I just moved to consulting after B school, and It's more money than I've made my entire life. After paying for rent and living expenses, I have 6000$ left over every month. My student loan payments are about 1200/month at 7% interest. I still owe another 95K on my loan. I have the option to pay more every month and reduce my overall interest paid.
Currently I put about 3000 towards my loan and 3000 towards my savings. Cont'd...

like

Getting married soon..looking to buy a house. Do I spend 250k for suburbs with long commute to downtown? Or $450 for house closer to downtown? 1h v 30m commute. But no guarantee I'll work downtown.

like

Anybody using Marcus high yield savings? 1.9%APY seems like a no brainer, just want to be sure I’m not missing anything.

like

I am financially secure (husband now has a high earning job) and looking at what options for "moon shots" at chances of real wealth generation with my years in Big 4 (10+). Month to month cash flow isn't a concern anymore so i can focus on opportunities for bigger pay days. Ideas from the hive mind?

like

Anyone using Edward Jones? Feel like we did a mistake and rolled over all my husbands retirement accounts from different employers and our kids 529 under them Jan 2020. Since then market is down and accounts lost20%. But the fees every month is pretty high around $200. I am worried to move it to fidelity or some other place and manage myself(not very confident), then I have to sell all of the Edward Jones managed funds and buy new. sell low buy low makes sense but don’t want to loose anymore.

likefunny

Trading Event Sponsorship for Party Rentals! Hey everyone - as a nonprofit we are having an upcoming event and having sponsors for it. We don’t have a huge budget so we are looking to ‘trade’ these sponsorships for table/chair rentals. Since we are a nonprofit are we able to give them the deduction value to claim on their taxes?

like

How do you manage your money?

I only bring in a little over $2,600 a month. After paying all my expenses, I get to put away $500 a month in savings but don’t have much wiggle room for anything else, including going out money.

I’m very privileged to have a significant inheritance and zero debt of any kind. I really wonder how my peers who have student loans, car payments, and even children manage to pay their bills and live so comfortably. Please share if this is you!

like

What is a reasonable rent increase %

like

How much do professional, high-earning (300k+) people put down as down payment for their first home / condo in Manhattan? 20% seems pretty high given the median prices, but looks like thats standard

like

More Posts

Who remembers this?

Post Photo
likefunny

What are "paper pushers" called nowadays?

like

Hello all,
Any openings for the BI tool Spotfire then please let me know. I have basics knowledge on Power BI and Power apps so can quickly pickup those projects as well. YOE 11+ Years. Thanks

like

Hey Jersey folks that work in Manhattan. Is your office talking about reopening soon? Will you have the option to still work from home?

like

Bain & Company Contemplating a move from Accenture Strategy to Strategy&, or Monitor Deloitte. Part of my consideration is the assumption that WLB is likely to be better than at McKinsey & Company, Boston Consulting Group, or Bain & Company. Could any of you fellow European fishies shed some light on the validity of this assumption? Sharing experiences would be highly appreciated.

like

I’m currently a Quality Tech 3 from MS. I moved to Indiana last year. I really would like to be an engineer. Can anyone point me in the direction that I need to go so I can obtain this venture?

Pros n cons of brillio... Honest answer please

like

Looking to specialize in privacy and was considering getting the CIPP/CIPM/CIPT. I already have my CISSP and CISA. Is it worth it?

like

Hi all!
I’m currently on my last year of university, pursing a computer science degree. I have yet to get an internship, or any experience in tech. Any advice on where to start? I would be attending part time in the spring semester and taking night classes so I would like to have something set up for January, let me know what you think. Thank you in advance.

like

I'm an EMR implementation specialist looking to transition into consulting. Does anyone know of any opportunities where this kind of experience would be useful? Thank you for your help in advance!

like

DA AC profile interview, what all is usually asked?
Any help would be appreciated. Thanks

like

Starting wage for a Radiology informatics application analyst? I live in Ohio. Thank you!

like

When they release DOJ? I got my offer letter already a week back .. BGV in process done with offer acceptance. When can i expect DOJ

like

How do you guys workout during tax season? If your leaving at 11/12 when/ how do u make the time?

Joined tcs around 1 month back and submitted all the joining related documents but still didn't received my employee Id.upon checking with hr i am getting information that there is technical glitch due to which employee Id is not getting generated. Is one else facing this issue ? What can be done in this situation ?

like

Having serious Monday blues! Who wants to talk and help? 35M in Chicago

like

Hi All,

Hope you and your family is safe !

I am an US tax consultant specialised in Fiduciary Tax services. I am looking for a prep/review jobs in PwC. I am well versed in prep and review of 1041,1099, hedge fund K-1s, and additional tax returns required for a trust/estate.

Please let me know of any job opportunities in the firm.

Thanks in Advance :)

like

Ok environmental scientists - what are the best eco-friendly changes we can make today?

like

K

Sent from my iPhone

Post Photo
likefunnyuplifting

Additional Posts in M&A - Mergers and Acquisitions Professionals

Recently left KPMG FDD for another FDD role at a growing firm and love it. PE focused. If you are interested in doing the same shoot me a DM.

like

Hey all, I’m considering a position with KPMG’s Deal Advisory / M&A service line as an M. What are your thoughts on 1) work life balance, 2) business outlook, and 3) culture? The salary is very competitive.

like

Does experience in financial due diligence with Big4 ensure good future opportunities ? Also how good is it for an MBA finance considering the majority of crowd I have found being CA on LinkedIn..

TIA

like

How would you rank the strategy firms in terms of their private equity consulting practices?

like

Any way of being in Ey s&o and being local? As in, is there a team that mostly does projects that are local (NYC)

like

Anyone have good resources (online or book) to learn about the finance function?

like

What kind of questions can one expect in interviews with the A&M PEPI practice?

like

Asked ChatGTP to name best consulting firms for software due diligence. It failed to name EYP, A&M :(

Post Photo
likefunny

Anyone on pros and cons of A&M PEPI group?

like

Has anyone done an M&A case study for a Corp Dev position? My interviewer told me it’s going to be a 5hr case study and I am a bit scared...Anyone knows what to expect in these?

like

How’s the pay and WLB at the corporate finance/IB subsidiaries of the big 4 compared to traditional MM IBs?

like

ACCA and CPA qualifications. How useful are they in the line of consulting. I work in the M&A space focusing on FDD. Happy to have a chat to see what qualifications if any are actually useful in our line of work.

like

🍁November Job Thread

Do you know of any opening or opportunity? Share it in the comments below!

Help another Fish. 🤝

likehelpful

Good book recommendations on the basics behind M&A deals and the DD process? Asking for a friend who is looking to start a search fund and has operational experience but no finance.

like

Hi all. I am looking to crack into the pe value creation space. Any tips or recommendations? Mckinsey senior EM and LBS grad with some early tenor investment banking experience; currently based in the middle east working for a public sector infrastructure player.

like

I'm leaving Deloitte (consultant - capital markets) for an analyst role in M&A (in house) in a relatively small company. How long should I stay and how hard is it gonna be if I want to join an IB or rejoin a consultancy ?

like

Ok, what does ‘F’ mean

like

What’s your favorite part of the M&A life cycle to work on and why? What about least favorite?

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

Scan your QR code to download
Fishbowl app on your mobile

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