I’m copying a report into workbook but the columns don’t line up to the report is there something I can do like to make it if this column name copy here. Not sure if this makes sense. I just fell like it really manual and there has to be an easier way

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

You should be able to use xlookup (best and easiest option), index(match), or vlookup

like

Is the original report in excel format or something else?

It’s in excel I’m using it for 8 work papers but each work paper only takes certain elements on the report I’m using

Related Posts

So we’re not going to talk about Mayo-Man? Or did I miss that conversation already

like

What are the best desi restaurants in the Bay Area?

like
like

Anybody from Deloitte , Need referral for a position

like

Hello Everyone
I have three years of work experience in SAP ABAP in one of the Big4. I am currently looking for a job change. I am an immediate joiner.

Can someone refer me to open positions in Deloitte USI or EY in Mumbai location?
Thanks.

I might get an offer in DHL, how are the company benefits, leave policies and pros & cons of the company ? Can someone elaborate on it ?

like

How long does it take for the HR (at DHL IT services) to release offer letter or come for negotiation after getting previous company payslips and other docs for BGV ?

My company covers in depth results each week, including meetings set/attended, wins, revenue, retention etc. I feel as if evaluating in such depth is detrimental to the psyche, as you never get to “ride the high.” In addition, some weeks are simply slower than others, and it’s not always representative of what the results at the end of the period or quarter will be. Is this not a big deal, and I’m I placing too much importance on it? Or is it beneficial to review results less frequently?

like

Anyone looking for a male flate mate in Pune please DM

I got a referral from someone at KPMG and used that link to apply for a position. How long does it typically take for a recruiter to reach out to you?

Number of emails you send and receive in a day? It's nearly midnight, and I'm still getting them. Does my VP have a life? I seriously think he's taking his antisocial tendencies out on me.

like

What shoes do you wear when it rains or snows?

like

Best area to live in NYC?

Toronto based but looking to spend 1-2 months this fall in the Big Apple to explore the city and do some professional networking. Will most likely be using Airbnb. Any tips or advice? 🙏

like

This is why I like Fishbowl, honestly - I don’t have to deal with creepy requests and can chat abt the industry, like how it’s hard to build a legitimate network in advertising. Agree or disagree?

Post Photo
likefunny

Looking to sublet a 1 bedroom apartment in Midtown Manhattan for $2.58k/month net. DM me if interested!

like

Thoughts on The Escape Pod?

like

Any tips on best groups or organizations to join in greater NYC/northern NJ area?

like

Anyone here ever been to RCA? Is it worth it ?

like

Co-worker 1: why are you so mean?

Co-worker 2: I’ll try being nicer if you try being smarter. Deal?

Me👂👂to 1 + 2: 😬🍿😂

funnylikesmart

Additional Posts in Excel Genius

What are your favorite excel macros to make you more efficient at work?

like

Right click menu. If you have a Logitech keyboard with no key to access the right click menu, press FN and F10 to pop open the menu. Very handy when you are trying to lose the mouse.

like

Is there a way to add 3+ criterias into a vlookup and if there are multiple results, to list them in different cells?

like

Hi! I am working on creating a Poshmark and want hoping someone could help me with a formula for excel. Here is Postmarks fee range:

After your item sells, we deduct a small fee from the final order price. For sales under $15, the fee is a flat rate of $2.95. For sales above $15, the fee is 20% and you keep 80%.

Photo attached is an example.

I was thinking an IF/THEN formula but would love someones help. Thanks! :) #excel

Post Photo
like

If i have a # set and a # that is the sum of a subset of #s, but don’t know what #s make up the sum, is there an excel/python function that will give all possible combos that cud make up the given sum

like

Looking for a shortcut key that is the equivalent of PowePoint's Ctrl + Shift + Up/Down arrow.

Essentially a way to switch row positions w/o replacing or inserting cells...

like

How would I create a bar graph that shows same store sales growth for 5 products that were promoted during different time periods?

like

Story time: I was on a trip about 15 years back, doing some Excel work on a ferry ride - your basic pseudo-database work that is so common. I started talking with the guy sitting next to me and after a while he commented on what I was doing, “You know, that’s really not what I designed that for…” (continued)

likefunny

Wait … xlookup is basically VLookup and Index/Match?

Is this seriously a viable alternative because what the hell have I been doing with my life?

likefunnysmart

What's the equivalent to a sumifs formula but instead of #s I want to bring in names. For example, i want to return a client name but only if it meets two criteria.

like

Just here to praise the Unary Operator. Old school programming trick that’s still very relevant.

In Excel it’s =--(Range =or other logic op Condition)

like

Help!! Time-sensitive:
Please tell me how I can achieve this:

To create concatenation of every possible combination of Type to Price for every ID.
I provided an example below with the outcome I want in the second table. Would prefer if this be down without a macro.

Post Photo
like

Anyone ever dealt with grouped rows / columns inexplicably stopping working? I have a big and pretty important model which uses grouped rows a lot (to click the plus and pop out more detail), and yesterday I opened it and it’s just all hidden instead of grouped. Any ideas how to fix?

like

My company has locked down our Excel so that we can no longer access the VBA Editor (it’s greyed out and Alt F11 doesn’t work). However I can still access the Word VBA Editor. Is there a creative way I can launch the Excel VBA editor via the Word version, or somehow run Excel VBA code via the Word version?

likehelpful

Does anybody know how to create a VBA code to automatically extract all the active data in a sheet on a different workbook without opening and manually copying to a different workbook? Ps also to create a reference cell to be able to change the file name and run macro so that it can use the reference cell to find the file and copy..

like

What is one excel command that is faster if you use a mouse?

likefunny

Would you rather use Excel versus CRM to store data and manage records? If so, why?

like

What’s everyone’s favorite keyboard? Thinking about switching mine up

Would someone please explain in a simple way when to use an array? Is it for every index match formula every time?

like

Please suggest some good training material for learning macros...

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