Looking to write a macro to rename a worksheet based off whatever is in cell A1... Anyone have any ideas? 🤓 👀

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

Should be one that you can just record, even if you don’t know vba

like

You want the worksheet or the tab?

Related Posts

Ordered a shroom grow kit and two kinds of spores. I've never taken them and always wanted to. Let's see if they do anything to rewire the brain like some people say!

like

I’ve suffered from workaholism for a long time. Thanks to a lot of great self help books and therapy, I’m no longer putting work on a pedestal and I’m spending a lot more time on self care and my marriage. But, unfortunately, I am now getting withdrawals, because my body is used to the daily adrenaline of throwing myself into work. It’s this terrible feeling of like anguish/unease in my gut, but I don’t have anything I’m worried about- it’s like my body wants to find something to worry about.

like

Anyone from GSK who can help with some questions?

Is bgv closed before joining LTI.
What are the things in BGV closed before joining and after after joining.

like

Any idea how long FIS global Pune is allowing WFH?

How is Ambit Asset Finance project from learning perspective? Asking since everything is internal. Internal frameworks and stuff. And since it's a huge project, people just get to work on chunks of it. How is it if you move out of FIS after working in this project?

Does anyone have experience with any of the following preschools: st Luke’s, St. Paul’s or st Stephen’s? We live in the montrose area and looking for some feedback.

like

What’s Accenture’s S&C bonuses like usually?

like
smart
like
like

Can we avail relocation bonus after two months from doj
Any one who availed relocation bonus recently

like

How to track my BGV in Natwest. I have submitted all the documents. How to check my current status? I received link from First Advantage. I have submitted documents.

like

I am planning to move from fintech to consulting after 2.5 years of work ex. Was curious how the pay and bonuses are like at top consulting firms like Deloitte/pwc/KPMG for software development roles

What is the entry level salary of Senior Analyst?

like

Have you ever hired a freelancer to make some memes for your community? I was thinking of trying this to get some new members.

like

Additional Posts in Excel Genius

I am looking for a way to link my Salesforce data into excel so I can have the latest data at all times. Instead of the typical download of static data that by the time I am reporting the data has changed.

like

Anyone else have a formatting pet peeve and get annoyed when people don’t have a blank first column and row in tabs? I.e headers/data in cell A1

My first manager told me this, and I’ve followed it to a T since.

likesmart

Just got a dell and getting annoyed learning new shortcuts on excel (had HP prior) - how do I automatically get to cell A1? Used to be CTRL-HOME on HP and Lenovo

Post Photo
like

What is the best FP&A tool, Anaplan, Jirav, Planful, Vena? Any other recommendation?

like

Is it possible to round a number (say rounding $98 to $100) without losing precision in following calcs? So I only want to round visually and I want the calcs from that cell to remain off the $98 not $100

likehelpful

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

like

Building an invoicing template for a construction comp but won’t be industry specific. I’ll be charging 5 hours at US$80/hr. Anyone want a copy of it for US$40 worth of crypto?

Context:
I spent 2 days last week and tmr fumbling over invoicing activity with the owner using a poorly designed invoicing spreadsheet. Last minute changes to already approved templates impacting >30 invoices is ridiculous. There will be a control sheet, an invoice generating sheet and a summary sheet. Q’s or comments?

like

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

like

My job often has me conducting analyses where we try to identify if product launch A has had an impact on B (cannibalization analyses) but super often they are inconclusive. I feel I need statistics / rudimentary data science here. Any idea what to study?

like

What are some of the unique use cases you have leveraged excel for?

like

How can I copy a formula from one sheet to another?i tried the simple Ctrl+C, Ctrl-V, but the formula refers to the old sheet.

like

I’m calculating a bunch of totals and averages by category on one worksheet by filtering data in different categories from another worksheet. However, when I change the filters, the previously..(cont)

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

like

Anyone know what these badges are?

Post Photo
likefunny

What’s your Excel horror story (worst crash, worst mistake, worst there-was-a-way-to-do-this-quicker moment)? Extra points for self-shaming

like

Presenting data in 2 tables that refer to the same pivot table as source. However, one requires a filter on the pivot table and when filter undone, values change back to original. How to tackle this?

like

For a linear regression analysis… the equation of a line is Y=MX+B, where M is the slope. So if I’m measuring a line across 365 days and M=.2, can I say that I have increased production by 20% over a year. Or is production increasing 20% each day?

like

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

like

How long did it take you to become good at excel? Like fast?

like

Hello. Quick question about formatting. I have an excel sheet with bunch of negative numbers, but some are percentage values and some are dollar values. Is there a way to make all of them have a parenthesis for being negative while keeping them still percentage and dollar value separately or do I have to target them separately?

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