Hi All,
Looking to automate a manual process for the client and thinking of creating macros for with VBA. Has anyone done anything similar?

In the process of learning but wanted to reach out for any tips, tricks and advice anyone may have.

Thanks I’m advance.

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

What is the process? But option explicit and screen updating are usually a must

like

So long as you can keep it from imploding until you roll off

like

Power Query if the data is structured as a table. VBA will work as well, especially if it's a scheduled task. If they have an RPA tool a la UI path or power automate desktop, can do it there as well.

like

What’s the manual process you are trying to automate? May be helpful to give some context…

Context: They copy and paste selected cells from one excel to another daily and type in their calculations. Hoping we can automate the data pull with VBA and then create formula cells that are locked in

Related Posts

like

Hi everyone! Local young woman here looking at a position at WellMed, pivoting from a career in tech project management. Is anyone here able to provide a referral or tips on the process? Thanks in advance!

like

Hey Accenture India any openings for java, i have around 9+ yrs of experience and currently working as project manager at CTS, I am an ex employee of Accenture.

Hello Fishes, guys could you please let me know whether I can use a bronze badge experience in a silver badge which is related to the same project experience? I am confused because there is a check box saying “Confirm this experience is unique and has not previously been used for another EY badge submission”

No pitch, just some research for a client of mine.

Aside from referrals, what is your biggest source of leads?

Facebook?
Google?
Physical Mailers?
Radio ads?
Your own radio program?
Something else?

helpful

How to get release from an important project?

like

What kind of modeling is required in ODD projects? What are u actually doing on the project? It’s described as M&A strategy ODD type of work

like

How to get released from current project in Wipro.

like

Hi Fishers,

43 days has passed in PDP with Timeline for me and there are still no projects avaliable on TMP based on my current skill set. I am upskilling my self as my Home manager asked me but this long period on PDP with Timeline is really making me nervous.
Should I be prepared for the worst and start looking for job change?
Anyone faced such an situation please suggest.
Thanks in Advance!

Post Photo
like

Looking for advice on business trips. My boss kindly asked me if I want to go meet a client out of state along with business folks. It will be my first visit to a client. What do you think are the benefits of these trips? I’m fairly new in my career and in-house so would appreciate any thoughts. Thanks!

like

Is there a minimum period you have to be working at kpmg in order to start looking to explore internal moves - from client facing to internal specifically ?

like

We lost an interim payment application for a client who has Steven Johnson's disease from a negligent prescription

Disappointed we lost

like

What does everyone wear for client meetings in a WFH setting

like

Any suggestions for leaving a financial advisor/planner role? Finance has me drained and I don't want to be client-facing anymore.

like

Hi,

Recently got an offer from GlobalLogic for the client gigamon. Do anyone have joined for the same? Please let me know.

I’m looking for feedback on PWC internal firm project roles, what is work life like?

like

Hello Boston folks...any insight on recruiters in Boston/New England area? Reached out to several but looking expand my coverage and possible opportunities both client and agency side. Any names & numbers would be most appreciated!

like

I have a dumb question... I have my first jury trial coming up in a few months. It's a 3-day auto accident trial. I'm the plaintiff attorney. My question is, should I have my client present the entire three days, or am I okay to tell them that they're fine to leave after they testify?

like

How is mphasis jpmc client

like

More Posts

Happy Janmashtami. Radhey Krishna.

like

So...what’s happening people

Recently accepted in offer in the NY office. What’s the culture like?

Hi Folks! Can someone please help me to decide which is a good offer and which company?

Mouser Electronics: (MEAN stack) they said they will match @fynd offer

@fynd : SDE-2 - 31 LPA (27 fixed + 2 Bonus + 2 Retainsion bonus)

can anyone please share the company work culture as well?

like

Hi everyone I am relocating to Hyderabad next month. Even though I look forward to meeting new people I can’t seem to ignore the fact that I will move away from family. My family situation is already complicated, my mom and dad are not on good terms so we don’t live together and when I move it’ll get worse. I am financially independent but I feel guilty for not being there for them. Is there any possibility of getting transferred to Gurgaon office(a lot closer to my home)if I talk to my manager?

like

Hi fishes LTI or Wipro or Harman connected services Please suggest which company is better join. salary offered is almost same. With respect to wlb and job security which is good?

like

Which company to choose?
BNP - X lpa
Persistent - X+4
I am confused because in bnp it is hybrid mode . And persistent atleast for now is remote work. Due to personal reasons, I need work from home, so leaning towards PSL but worried about wlb. Please help...

like

Now that Facebook is Meta, I thought I’d just pitch MANGA as the new FAANG…

like
like

How much time PwC AC BGLR takes to complete fnf and service document . PwC

like

Thoughts on DDB Chicago, more specifically the Army account?

Hello

Looking for a 3bhk semi furnished flat for rent in JP nagar and Jayanagar for a family in a society. Would like to connect with any leads

Thanks.

like

Going through some relationship issues and having a hard time focusing at work the past couple of days. Not sure how to prevent my personal life from affecting my work.

like

Tax SM’s at RSM - what is your salary for a medium-high COL for 2-3 years of tenure?

like

Hey fishes, I recently joined this bowl.
I m having 10+ exp in Manual Testing and looking to upgrade myself into Data Analytics so can you please guide me
I hv read existing comments and found that Python, Excel, R these r hot topics but can anyone pls share some courses, links, material to start with it.
Thank you.

Anyone interested in group conversation and prepration for Java 8, microservices, spring mvc and boot? Interview preparation basically.

like

I know this is the DC bowl, but does anyone live on or near Georgia Ave in Silver Spring? I’m moving across the country to the downtown silver spring area and am considering moving into the Thayer & Spring building. Can anyone give any insight on the noise level?

like

Why are there so many job postings that I have applied for but nothing happening? Are the jobs that are posted truly open? I know we are in 4th quarter and wasn’t sure if corporation’s like to hire then?

like

Hi guys currently I'm working in a project with very stringent timelines. Sometimes we need to put more than 13-14 hrs each day. There are 4 members in my team. Two are involved in database prt and me and my lead are involved in the front end and middle layer prt. Somehow my lead is not at all pleased with my work. And even if I try to talk to him for something he is completely rude. Sometimes it makes me that I m completely useless. Even the other team members are following the lead

likefunny

Our senior creative leadership keep talking about winning Cannes Lions and D&AD pencils but none of them have actually won any since 2007 (that’s 14 years 😭 ) and between all three of them they’ve never won more than a couple of silvers, a couple of bronzes and a couple of in-books (that’s with a combined experience of over 60 years 😭). They have no clue 🤣🤣🤣😭😭😭. Tell me something about your agency so that I can feel better about the hell-hole I find myself in🙏

likefunny

Additional Posts in Excel Genius

How do I compare two sheets to make sure they are identical?

like

This is dumb, but. How can I pull and average the numbers in column b associated with the 4 values in column a? So, (sum of all As/total number of As) without filtering?

Post Photo
like

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

like

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

likehelpful

Anyone have an app or Excel spreadsheet they use to keep track of utilization? We just switched systems and our new system doesn’t give us a real time balance of our utilization rate (cont)

Still don't have xlookup. #fomo

like

Anyone know what these badges are?

Post Photo
likefunny

Anyone use power query before? My goal is I have multiple look up values in one cell (separated by comma) and I need it to look up those values and return values from another table which also may have multiple values (separated by comma) anyone know how to do that? I played around with power query today but it wasn’t giving me what I wanted

like

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.

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

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)

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

Can dates be grouped just by Month-Year in pivot tables on a Mac without having the year as its own dimension?

Post Photo
like

What are some common reasons that a COUNTIF formula might not be working correctly? I'm using the correct range and value to count. I'm not seeing "ERROR" but the values aren't correct (it's not counting everything). Thx.

like

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

like

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

likehelpful

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

like

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

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