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

Recently i joined cgi but the project does not ses much good as per tech stack.Is there anything I can do in this case.I am tagged to this assignment but project has not yet started.Please help me with issues?

Was there any affect on your project due to Melbourne shutdown..........I see another potential lay-offs wave coming for Deloitte😬

like

Business practice: "can you guys build a model that overlays where Coronavirus is going to break out with client sites"

likefunny

Hi everyone, I'm eager to get some B.A or Project experience, having recently achieved my certification in Agile Project Management and I’m looking for new opportunities as a Project Administrator or Coordinator. I am experienced in project administration, sales, and PA work. I'm especially interested if anyone has any roles (remote or hybrid) in the U.K. Thanks in advance!

like

Haha it's a mix of product management, project management, product development, consulting work, technical stuff, analytical stuff. Literally anything the project needs to succeed haha

like

Nagarro 🐠🐋🐟, Have got a preference mail for Project allocation
1. Technology - I have added my tech
2. Colleagues - asking for Nagarro mail id (don't know so will leave blank)
3. Line Of business - Please suggest which are best Client projects in Nagarro eg Retail, automotive, Finance
4. MNC - Yes


Need Suggestion for Point 3, also if have onsite opportunity will be plus

like

Hi Fishes,

I have offer from both nagaroo and Publicis sapeint. Project is not decided in PS but Nagarro hire me for the ZS Client itself.

I am looking for job security, wlb and good project to work on.

Fishes, can you please suggest which should I join?

like

I have been a PM at my company for 2 years now, with a years prior experience as associate PM. I got promoted before my certification, but was told if I did not get a PMP or ACP I would get my promotion taken away.
Received the ACP and have not seen a raise. Now we have a girl that is getting a 15k raise and going straight from Project coordinator to PM (with one year experience) and no certification. She will now be 5k less than me. If she gets CaPM she gets a 5k raise. Wong to feel slighted?

like

Hello Everyone,

I am currently learning Google Project Management Professional certificate course to pivot into PMO.

I would request all the readers, if they can refer me or assist me in career pivot , I will be highly obliged and really appreciate your help.

like

Hi
Any one working in Wipro for UHG - United Health Group client. How is the work environment and technology stack. I might join there as a Architect at C1 band.

like

My current project winds up on 31st December 2022. If I resign by mid/end of this month(expecting a few offers), would CG persist with the 90 day notice period with me serving majority off those on the bench or would they consider releasing early once the client stops paying? #Capgemini #NoticePeriod

I know notice period at thoughtworks is 2 months .
Given there are a lot of people on the bench , is there any chance that the notice period can be reduced down ? I'm not on the bench . Recently I joined a new project .
Developer+ senior consultant

like
like

Hello fishes, I have an offer from Marlabs for KPMG project. I don't see much info about the company. Need your suggestions and inputs before I make a decision. TIA!

YOE- 6.6yrs
Profile- Network Infrastructure
Offered CTC- 19LPA

Hi everyone. I’m a front end software engineer. I’m interviewing next week for a solutions engineer at a company I really like, which I mistakenly applied for as I saw they needed ReactJS, JavaScript, HTML/CSS. Upon reading the job description, it’s clear I will be doing a lot of sales and client consulting over actually coding. I know they have a FE SWE role open. How would you approach asking the recruiter if there are any SWE openings I could be considered for instead ?

like

When the client has a travel ban but has no problem with us traveling to them. 🙄

likefunny

My ECD keeps changing our work before it goes to client and it's cost us making good work. Our books are suffering because he can't get his hands off the tools. Our books are only full of spec now.

like

(1/2) For those w/ technical backgrounds: how did you develop executive communication skills? I’m a year into MBB (post MBA) and have had really great reviews on client, problem, and team

Hi guys, I am a CFA & FRM holder passed out of tier I b school. I have 8+ years of experience in equity research & project financing roles. I'm taking a break & would like to work on hourly basis as a consultant (part time) for some months due to personal commitments. Please let me know in case any of you guys can offer me anything!

like

Hello all! Has anyone completed the Professional Certificate in Product Management program with Kellogg Northwestern?

I’m currently a technical project manager looking to pivot into Product Management. I’m wondering - is this investment worth it? Interested to hear your thoughts.

For context, I graduated in December 2021 with a business degree and have 1-1/2 professional experience in tech/marketing/project management.

Thanks in advance!

like

More Posts

Does anyone here work for any public accounting firms in the Charlotte area with a decent work life balance? I am looking to go somewhere where I can focus on a few clients for longer periods of time rather than constantly bouncing around. I find it much less stressful to put in longer hours if it's a client that I have been scheduled on long term.

like

Relocating from the west coast in late spring. We have three kids under 6. School system is important to us. Thinking relocating to the Lake Norman area or Fort Mills. Pros and Cons. Looking to purchase a house and sq at least 3250-3500 min. Any advise for the area.

What is the salary for a manager vs senior manager in sap practice EY - Toronto Canada?

like

For those whom 𝑺𝒖𝒄𝒄𝒆𝒔𝒔𝑭𝒂𝒄𝒕𝒐𝒓𝒔 is everything, wishing them a very Happy Valentine’s Day 😀❤️🎁

#SAP #SuccessFactors

Post Photo

Hi Fishes,

I was offered RSUs for the first time as part of my compensation. I think I understand the concept as such but there are a few intricacies I was looking to clarify. Could anyone let me know if my grant date is 9th nov, 2022 and vesting period is 1 year, will I get RSUs allotted at the price of stock on grant date or vest date (in this case 9th nov, 2023)? Happy to connect in DMs as well

Thank you for your time!

like

Got added to the client's mailing list so now I get typo-filled emails about "This person is covering as receptionist for 2 days" and "Who needs a mouse pad". ugh, can I unsubscribe?

like

Looking for help to think through exit opportunities:
Big4 Transformation Director, current 220 Base, 10-30% bonus. New York.
Any constructive thoughts on how to pitch transferrable skills to: PE (Ops), Biz Ops, Start Ups or even IB without the modeling experience?

like

Hi Folks,
I am looking for referral opportunity at SAP LABS India for Developer Associate role.
Please let me know if any is available. @

like

Within my first year of Consulting, really struggling with the hours amongst other things. Spoken to a couple of people internally and the advice is to get on to projects with bigger budgets and therefore bigger teams/more support. I want to wait until I hit the one year mark before making a decision on whether Consulting is for me or not. Curious to hear from other experienced hires..how is/was your first year?

Sakarya for a Senior Principal Consultant at EY GDS
1. <30L Fixed
2. 30L - 40L fixed
3. 40L - 50L fixed
4. >50L

like

It is very much probable that the US and some of the EU countries might venture into recession.

Considering the same, is it advisable to join EY GDS at this juncture as there is a probation period?

like

I want to join Adobe as a Product Manager.Any suggestion for preparation would be helpful.

like

How much does ibm give in glasglow onsite to 7A ?

like
like

Anyone from Deloitte SCNO here ?

Thoughts on Jones Day?

funnylike

Starting IVF in a month - any guidance in prep for it, things that may help increase success for egg retrieval or anything like that? I started taking supplements advised by my doctor, but curious to hear of anything else! Thank you SO much!

like

Openings for manual testing 1 year experienced and freshers Light & Wonder . Ping me if interested.

like

Additional Posts in Excel Genius

What are your top Excel ninja tricks? Ones that few people know...

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.

How do I easily find any cells that are hard coded vs formula? I have 10,000 rows of data and column F is supposed to be a formula based on columns C and D, without clicking into all 10k cells in column F how can I make sure formulas are there and not accidentally hand keyed over?

like

Anyone know what these badges are?

Post Photo
likefunny

Best websites to get more of a handle on Excel as a beginner-intermediate?

like

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

like

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

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?

like

Still don't have xlookup. #fomo

like

Would anyone be willing to teach me vlookup?

like

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

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)

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

likesmart

Recently made a job switch and have been using a lot more excel. Any free resources to help build a solid foundation / fee based courses to help improve my skills?

like

Anybody use a personal computer for work? How's your experience been, any horror stories/watch-outs?

like

I am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

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

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

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)

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

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