How can I use a cell value (user input) to control the number of rows in a table? For example, I want to make a dynamic table containing a number of rows specified by the user. Thank you!

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

If table rows are the only populated cells in th columns: =counta(a:a) , you may want to subtract 1 to adjust for the title row.

Otherwise in vba:
Sub xxx
i=1 'table starting row #
count=0
while(not(isempty(cells(i,1))))
Count=count+1
i=i+1
Wend
End sub

like

You can do this without vba by using conditional formatting and lookups paired to town number

like

Row* sorry

like

Can you not format as an Excel Table, which is a dynamic structure anyway? What is the use case?

like

Like I want to ask an user how many categories (rows) are needed for one section and change the rows within this section accordingly. Each category (row) will require further input.

Related Posts

Guys what are the option to think of if I am planning to move out from EY .I work for Tax support (PAS-CES ) not sure which domain to apply if I am planning to move from EY. I'm worked for 2.6 yrs and my take home salary is just 24-27K , so I was thinking if I should think of a job change if so please advice me on which firms and domain to apply .-Thanks in advance

like

Diwali gift scene at GDS??

like

I opt for NPS in FBP, but not able to see in salary slip, not in nps app as well. Any suggestions where I have to see? EY GDS

like

How much % rise are you expecting this year round in your salary?

like

Two people on my team of four quit today. I am now the most senior person, with just over one year of experience. Wtf.

like

Has anyone shot a campaign with real patients? How long do you plan for casting?

like

Hello,

I am looking for a job change and feel that I don’t get enough interview calls as my notice period is of 3 months. Every company want immediate joiners.

What can I do here?

TOYE - 10 years
Skill set - RPA, UiPath, C sharp

like

which firms are still hiring seniors in the west for accounting advisory type roles?

Anyone know where to get free covid testing near west loop with fast turnaround time for results?

like

Tagline for award shows post COVID

like

I have been in my position for 27 years and have never seen such a state of affairs as I have this year (but then, with the pandemic, who has, right?) Well, long story short, we've gone hybrid (some in person, some online). The teacher has been out with surgeries and covid. I have been teaching both groups at the same time. Sometimes a sub for help, sometimes not. I love the kids, but really?

Has anyone been to the UK lately from the US? What are the Covid requirements / restrictions? Thank you!

like

My gpa fell to a 3.0. I was working multiple jobs in college and had one really bad semester due to a traumatic event I went through. What are the chances the firm revokes my offer during a pandemic?

like

If you started a new full time job a month and a half ago and are finding that you dislike it, how long should you give it till you jump ship, or decide to freelance?

like
like

Has anyone ever actually seen/had to cover up something sketchy on an audit?

like

My HR rep told me that to apply for your CPA license in MA you only need 1 year of work experience, not 2009 billable hours. Didn't sound right- can anyone confirm/deny?

like

Hubspot is getting way too expensive for my small business and they don’t care at all that they are pricing loyal customers out. What’s a more affordable alternative?

like

Looking for insight on business immigration firms in LA. I worked as a judicial clerk/staff attorney at the immigration court and occasionally handles decisions involving employment-based immigration, non immigrant visas, and waivers. I’d like to get into business immigration and eventually advice and counsel for employers, so I’m wondering whether I should be looking into full service firms with L&E and immigration. Thanks!

HR professionals,
If you could immediately acquire any new skill, what would it be? If you're comfortable doing so, tell us why.

like

Additional Posts in Excel Genius

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

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

like

Hi there! I'm working on the data modeling assignment and looking for some tips for data mapping (how power query or vba can help). Thanks!

like

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

How to change a date field from 2002/01/15 to YYYY-MM-DD. The right click and date selection is not converting it for some reason. Even tried to do a custom field but it’s not changing :(

like

I have 6 months left until I start my first consulting job, I want to use (and improve) my Excel skills via volunteering, where should I look to find such opportunities? (UK)

like

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

What’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

like

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

likehelpful

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

like

How do I change line style@back to default on excel? Accidentally click on one, and now it wants to use that style every time. I just want to be able to use the ones in the typical drop down

like

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

like

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

like

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!

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

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

After I set a print area, how do I showcase the page 1 - page x in the excel sheet and have the background be grey?

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

why is index match superior to vlookup?

likefunny

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