Sheet B pulls data table from Sheet A. Sheet A is my base sheet for inputting data and will use Sheet B and other similar tabs to pull info from A and run calcs accordingly.

Question is about adding rows to data table in Sheet A. Will often have to append data in Sheet A by inserting rows in middle of data like shown/highlighted. How do I ensure the tracker ID column starts at 1 and counts sequentially all way to bottom, even with the newly inserted rows. Thanks in advance!

Extraversion. Intuition. Feeling. Perceiving <3

Any time period to switch between projects

Office chair recs? Looking to upgrade

Any standing desk suggestion for 2 people for WFH? We have four monitors in total. Budget desks will be preferable.

Hertz or Avis, and why? Hertz for me because everyone I know that uses Avis says it takes forever to earn free days.

Hot take. Is FAANG even a thing? Or was Cramer just worried about the acronym if he took out Netflix?

How you guys are surving in EY. Its been 9 months no peace of mind. Counselors and SA are shouting at me, working with deadlines. I'm done with EY.

How does your firm compensate attorneys who bring in new business/clients?

Covid-19 coverage: what are you seeing? Where are we headed?

Does anyone know if an expert is required to prove Plaintiff’s economic damages (loss of earnings) in a personal injury suit in Texas?

Hello please can I find Victoria’s boot camp I keep hearing about this being great to study for shrm exam but I can’t find it anywhere thank you

Where’d you get your MBA? Looking at a 10 course program 30 cr hours for 19,000 USD. The school is AASCB credited. It would be an MBA with a a focus on management and transformational leadership.

Does anyone know of a coworking spaces that focus on creatives and/or marketing companies? All the ones I know of like technexus, wework and 1871 in Chicago are tech company focused.

First time done with work at 6.30. Drink anyone? 34 M here

Celeb sightings! Share your experiences, ie who, where, when?

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

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.

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.

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?

Dear auditors, please explain how you pick samples for substantative testing.

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 😭

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)?

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.

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

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?

Is there a way to do a multilevel sort but keep certain rows from sorting? I’ve got a fairly involved project plan with different levels and I need to sort by the dates on certain rows but keep other rows intact

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

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?

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

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)

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

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

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

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?

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 🙏