Can I write a macro that will fill out a table of information based on cells that have comments on them? For example, if G12 has a comment, I want to pull text from that comment + data in A12.

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

I don't know how to write macros so it may be done better. I would do an if statement with a concatenate fx inside

like

=if(A1<>"", concatenate (A1,A12),"") (assuming A1 is the comments column

Yes you can

like

Very easy to code in macro, but as original commentator mentioned this is probably best done through a formula such as concatenaste

like

To clarify, the column itself doesn’t hold comments. Rather, the column has numbers and someone may have inserted a comment on a particular cell

Yes. You call up the comments property using, for example, Worksheet(1).Comments

Related Posts

I'm preparing entries for Cannes Lions and noticed they require high-res JPEGs in CMYK format. Wouldn't that greatly affect the image color? I'm not sure if I'm missing something here...?

likefunny

Guys I am planning for a business to set up in my spare room(Completely new home). Please suggest some ideas like renting a room, converting room to photo studio or so on. FYI I can’t do airbnb in Anaheim California as doesn’t allow short term rentals due to competition for hotels.

like

Got an opportunity as a BDR at Klaviyo. Does anyone have past experience here that can share light on company culture, compensation, and growth opportunities?

like

Hello Fishes!

I am a Mechanical Engineer with around 5YOE in FEA in automotive sector.
I am finding it very difficult to get a FEA job in Mumbai (moving out from Pune). Do you think not many FEA jobs are there in Mumbai? Should start developing myself for another role which will bag me a job?

TIA

like

I landed my first job in tech as an IT Analyst. I want to be a Project Manager, do you think it’ll be hard to make a transition to Project Management.

like

Any Bain 🐠 willing to refer me in?

funny

DM your EmailID with JobTitle to Apply in LTI- Larsen and Toubro Infotech.

Post Photo
like

How do you do your retirement savings calculations? Online calculator? Your own excel spreadsheet? Any caveats you plug into the model? Hoping to improve mine, TIA!

like

How is it going in Canada? How is the job scene?

I wish I could tell my lead how much i like him.

PS: He's engaged.

like

Are hours in FDD Pwc in NY really that bad ? Do you work every weekend on deals ? How many deals as Senior do you work on throughout the year ? I’ve got an offer but I’m still hesitant.

like

Currently a marketing designer - any particular skills needed to branch into a visual designer role?

like

been in industry (small companies) for 5 years with an active CPA. Wanted to get in SEC reporting roles but almost every company requires 2-year public accounting exp. Now applying for public accounting firms entry level positions but almost all firms HR asked if I had ever worked in firms. Got rejection emails from firms all the time. Is this a dead lock? firms exp matters much more than a CPA license?

like

How is the wlb in legato

like

SAP Labs is well renowned for its WLB. Please share your experiences on WLB. Is it still on good note or its poorly impacted in ur team!

like

Who here has been at reciveing end of a UPI scam?

likefunny

I am currently in the offer negotiating stage at a FAANG. When should i talk to their immigration team about the H1B transfer and the new I140 application (when will they do it and ehether EB2 or EB3 etc.)

like

Is getting into a top-20 school out of the picture? I had about a 3.1 GPA from an okay school, and have never been great at standardized testing. I’m getting into community service, and have a decent resume over the past few years.

like

Hello fishes. How much should a frontend software engineer with 4.5 years of experience earn in bangalore? I am good at angular with ngrx. I also know react.

like

What benefit do employees get from referring someone to their company? Why do so many strangers do it for each other?

like

Additional Posts in Excel Genius

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

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

I have been given a csv file and one of the columns has multiple properties. I want to split each of the properties into their own column. However every row doesn’t always have them in the same order and may have slightly different properties. Is there a way to sort this efficiently?- picture for reference, columns v onwards is how I have split with text to columns currently. Any help is greatly appreciated

Post Photo
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

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

Time to convert to xlookup

Post Photo
likefunny

Just created my first macro! Super proud of myself! #humblebrag

likeuplifting

To see a list of all tabs you right click on the arrows to the left of the tabs. Is there a shortcut to this without a mouse?

like

To all heavy Excel users, what brand laptop are you using and how’s it working for you?

like

Need to create an P&L for a physical therapy center without using existing excel templates. Just cap payment info, lease price, team member salaries and supply costs.

Seeking formula support…,and open to other tips and tricks.

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

Our group is exploring Alteryx. When I review im Excel, I can click on a cell to verify the formula. In Alteryx, I will get a hard coded Excel sheet. What are some ideas to make Alteryx reviewable?

like

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

like

EY trying to move away from Excel . Think it’s possible? Want to see it happen?

like

Anyone know of any roles or companies that hire you with basic excel skills and train you in advanced excel/analytics?

likehelpful

Does anyone use XLOOKUP over Index Match? Why /why not?

like

I made a spreadsheet to track my dating success:

The spreadsheet has an input tab with qualitative and quantitative data as well as a dashboard that automatically updates 🙂

Post Photo
likefunnyhelpfulsmart

Alright. I am very much so not an Excel genius; I have the Excel skills of your 90 year old grandma who just owns a Jitterbug. Im semi-tech savvy (young millennial), but I’m new to corporate after transitioning into my role from the classroom. Among some skills I know I need, understanding basic Excel functionality is the most immediate. Does anyone have any recommendations for a very novice look into Excel? Thank you in advance!

like

Is Macabacus or any other add-in actually worth it for Excel & PPT? In LMM - MM M&A roles.

likehelpful

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