How useful are Macros and VBAs for tax prep?

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

A lot

like

Anytime you have to manipulate data in excel (e.g copy data from one file into another) on an ongoing basis, VBA can add value.

Related Posts

How many of you are involved in share trading/Derivatives Trading apart from your current job? And how are you managing it? What return are you generating?

like

If I make 100k a year how much am I taking home in reality?

funnylike

I’m leaving my job soon but I’m wondering if I should be truthful when I hand in my letter of resignation. There’s a ton of reasons but it boils down to: I’m worth more than they can pay me and I need to pay off these student loans. What should I say?

like

Has anyone actually received their reimbursement for filing taxes in multiple states? I got told that it would process with payroll last Friday but I don’t see it in my bank.

like

What’s some good digital invest account platforms?

like

Sold first AAPL put 15 mins ago mid 355. $680 profit on that one. Will wait til probably sub 350 to sell the next one, or may buy back if we go back above 360

like

Boss Makes a Dollar, I Make a Dime,
and I have given up all my personal time. Going for 105% Utilization

Post Photo
likefunny

Hi Fishes!

My cousin has moved to another company from DXC technologies.
In DXC, PF amount is not credited in to EPFO directly.
We have UAN and it looks like not activated.
How can we transfer PF amount from DXC to EPFO portal?
There is no relevant response from DXC till date.

like

If you didn't have to pay off any more of your student loans what would you use the money for instead? I'm stuck between something impractical like a trip somewhere or something I need like a new car lol

like

Should I put $20K towards my student loan balance of $230K before the no-interest period ends or max out my 401k, which I have contributed nothing to this year. I’m 25. Employee matches 4%.

like

Anyone else into Bank Bonus churning?

like

Buying a house with monthly expense of $4900, although my current rent is only $2350. My total HHI with my husband is about $310K. I’m feeling weary of spending this much but we live in a HCOL area near a major city and we have high taxes. It’s hard to find anything decent under $800K. Should I just suck it up in order to be a homeowner?

like

Finished Rich Dad Poor Dad and appreciate the emphasis on creating alternative cash flows (vs. just income). Does anyone have book recommendations on creating wealth? I've focused heavily on income + 'safe' investing, but intrigued to learn more.

like

as another fish. have 13k left in car payments for another 40+ months, would you recommend doing a 10k onetime payment or investing that 10k instead. better to lower debt or keep paying monthly cost

Why have cryptos crashed so much since yesterday eve?

like

Let’s talk credit cards! Is there any one which has 0% foreign transaction fee? (Like Revolut)

like

Where do first year associates / business analysts typically live in NYC? What’s a realistic rent budget?

like

Feel like I’m going to turn out to be a loser doing ID and be making crap money forever.

like

Senate hearings on crypto at 10:00am followed by the launch of the world’s largest rocket at 1:30pm by spaceX. Coincidence? I think not! To the moon we go 🚀🚀🚀

likeupliftingfunny

More Posts

like

Where in Dubai do you live? Which areas would you suggest for MBB consultant? Thank you

like
like

Hi all,
Please help me with the in-hand salary for this breakdown?

Post Photo
like

How much we can expect for 11 Yoe and Sharepoint/power platform developer?

like

Hello, what should be the average CTC for a Campus Recruitment Manager with 10+ years of relevant experience. Tier 2 city. Tier 1 IT Company. Pls help.

like

Worst luck ever. My group was very slow from Jan through may, so I won’t hit my hours, but am now (and will continue to be) very busy…. About to do 1990 hrs the most painful way possible. Fml.

like

Planning to exit tech firms as a mid to senior level roles. What are some possible sources I can reach out at to make this happen?

like
like

Do people 4-5 years out of b-school still put GMAT scores on resume? I have other markers of academic qualifications (schools, GPAs) on there, but wondering if should add standardized test score.

like

In a Big4 deal Analytics group that’s not premier with no path to partner... should I try to move to MBB/T2 to gain traditional consulting experience or try for tech/FAANG... I just wanna make money

likefunny

I have an offer in the product team of Publicis Sapient and Dell with almost same package. Which one is better in terms of WLB, learning and hike ?

like

7 YOE Mainframe & Unix
Not good at COBOL
Good Communication
Team playing leading skills
People skills
What may I learn to climb career ladder ?

I am starting a new job where I will be investigating sexual discrimination cases. Employment law will be a new practice area for me. Do you have any recommendations on good learning resources? Any treatises?

like

Deloitte Manager or IBM Manager?? Please suggest.
Almost same fixed package.. skill SAP Functional Close to 10 Yrs experience.

I'm currently interviewing for a hardware internship (at a startup). I've had a phone interview, a 30 minute technical interview and now I have a 2-3 hour interview. Is it just me or does this seem a little excessive for an internship?

like

Had a fight with my MD or let's say more like argument. After that the next 2 months was endless nitpicking and pulling me for mistakes that aren't really in my control.

Post 3 months, I apply for a transfer. Transfer process delayed for some process reasons
No negatives/issues in my f22 feedback. Utilization above target. Way Above average
Recently fired without reason
Who should I escalate to?

PS: Ignore typos. Written in anger

like

Are there any fundamental differences between a salary negotiation during the start (applying for the job) vs. Salary negotiation during a performance review (you’ve been employed for x time and looking for a raise). I’m in the latter and wondering if there are any maneuvers that are different I should be doing.

likehelpful

When making a PBJ I double dip my peanut butter knife into the jam

likefunny

Additional Posts in Excel Genius

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

Hi all! Is there a way to easily copy over all the rows from multiple sheets into one consolidating sheet? We have 32 teams filling out transactions in their own tabs and need to consolidate all tabs transactions into one long list of transactions. Thank you!

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

Hey!

What are the less known skills in Excel worth learning which are also high in demand in the market?

PS: I am starting off on Fishbowl so please support with a ❤️.

like

I have a large dataset in PowerBI (7m rows) and I’m trying to condense it to pivot in Excel by aggregating the data. Does anyone have experience doing this? How do you pivot and export in Power BI?

like

Any weekend or online excel course recommendations?

like

Out of curiosity, what percent of your work/analyses are Excel based? And what other softwares do you use the most (Tableau, PowerBI, Alteryx, etc.)

My work has been 90% Excel based 10% Access/SQL based and friends at other firms seem to be using way more advanced programs.

like

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?

like

Current IE here. What are some Time Motion Study Softwares that are out there and you use in your jobs?

like

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

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?

Anyone know why a SUMPRODUCT cell would return to zero?

The error said ‘inconsistent formula’... (cont’d)

Hey guys, I have a Google spreadsheet where each cell has multiple links separated by semi-colons.

How would you get the links to show up in different rows WITHIN a cell? (Pictured is what I want to achieve).

Thank you so much🙏

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

Hi! I’m trying to create a macro that pulls a copy of a sheet from a file with a certain date in the file name into a new workbook. Is there a way to do this?

Any book recommendations on excel modeling for real world business applications?

like

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

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

What's a simple way to explain data organization to people who don't use formulas very often? People on my team love creating many tabs instead of adding columns for recording the same type of data...

like

Anyone have a good source to learn sql

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