I'm trying to make a consolidated financial statement and each entity is on a different worksheet within one workbook. What's the most efficient way to 1) make sure I get all line items in there and 2) sum the line items that are the same.

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

I’m thinking set each cell equal to the respective statement and line item titles and then Index Match to populate line items with appropriate numbers by year.

Related Posts

What are some of the common exit options for the manager level? Looking for TC to be close to or over $200K. I know it’s heavy tech in the US, but what does that translate to here?

like

What's an average SE salary with 3 years experience in Ontario, Canada ?

like

Any Additive Manufacturing Engineers here? What’s your salary and years of experience in AM? Currently I’ve been in AM for 4 years but I have 14 years of experience in design engineering in total. I’m at $95k

like

Has anyone done provider network design work for a health plan? If so, how did you like the work?

like
likesmart

What is the average salary of an electrical engineer 4 to 6 years experience and Master degree - in Luxembourg ??

like

Working with a friend on the best way to get into teaching. Is subbing a good way to “get my foot in the door?”

like

Anyone have any insight on Blue State Digital? Good, bad or ugly?

likefunny

I’m an AE and my AM is leaving. As we are having no luck getting a new AM. What is an effective way of being promoted to an AM and what is your advice on how to progress and proceed without a current AM in place an in agency setting.

like

Do you think winning awards help you get better positions? I feel like people barely see the awards I've won on my resume. It's more discussion about my experience.

like

Is the SPHR or PHR license necessary to pivot into human capital? I have a MBA from a Top 15 school. Any thoughts?

Diversity is just a gimmick and mostly on papers, I found females are not respected in corporates and are been opressed. Has anyone faced the same

like

How often are you ladies, living with their SO, having sex in the current situation? Pre COVID for me it was 3-4x a week but now he doesn’t seem to be into it. Spends his day working & nights gaming😭

like

How is the PM Freelance market in Chicago?

I am booked at an agency that is filled with toxic people and I got offered a freelance job at a really great agency. I am two weeks into a four week booking but they said that usually keep freelancers on for a really long time. Right now I am only working on edits. Do you all think it would be OK to tell the agency that I’m currently at that I’m going to leave for another booking or is that really bad?

like

PwC Advisory or EY FSO for M level role?

likehelpful

Had an interview for SM role at ACN 3 weeks back but haven’t heard back. This was skills round interview after HR round. Am I still in the game or it’s a no? Don’t want to followup with HR just yet.

Looking for info about the engineering culture at Netflix from the perspective of someone who identifies as a woman or non-binary person and is also a person of color. Do you feel safe and included? Would also love some input from someone in a leadership position, do you feel supported as a leader?

like

Additional Posts in Finance

Why all sponsors are looking for the same purple unicorn: a proprietary deal for a large uncomplicated asset that spits cash and has no capex or working cap reqs. Guess what, doesn't exist lol.

like

Hey all! So I got a job offer for 95k for a Sr. Regulatory Relations Specialist. Is this the average salary or a lowball offer? Personally, I am having a hard time finding the average role salary posted anywhere.

like

Interview tips for a fund management company- entry level role? (Other than researching about the company)

like

Any MDs or VPs here... what is your take on Trump's decision for H1B visa? What according to you an analyst should do if she/he does not have an H1b yet?

like

old people bad at email causing congressional hearings dot tumblr dot com

like

Do you wear suspenders? You're probably a dickhead.

like

Bose QC35 or Bowers and Wilkins P7 Wireless? I got a gift card this year and trying to buy solid headphones for train, traveling, etc. I really like them both.

like

Any experience with Air France business class?

like

God damn I'm too young to be balding already. Should I shave it? I'm relatively fit and stylish.

like

Favorite excel shortcuts that many of us might not know about?

like

What company would you never want to work for and why? Company need not be in finance.

like

What has been your Tinder stories?

like

Will the pandemic actually lead to permanent changes in business continuity/operational risk management, or will companies fall back into their old ways after this is done?

like

Uber driver awkwardly asks if he can ask me a question. I say, "Sure." He says, "What do you think is the most important thing in life?"

like

GS vs CLE 🏀🏀🏀🏀

like

I think my MD got to where he is now based solely on flattery and politics.

like

How to deal with insomnia? I average 4 hours of sleep a night and am always exhausted during work, but can't fall asleep! Do I just take melatonin forever?

In a shit relationship... need an exit strategy. SO is psychotic and clingy AF.

like

Everyone says play the game of politics; make people like you. What are some tips for putting on your game face and making people both below and above you like you, when you may not like them equally?

like

Been hearing a lot about the college debt burden. Let's compare... what's the debt number you've accumulated since graduating?

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