Welcome to DU! The truly grassroots left-of-center political community where regular people, not algorithms, drive the discussions and set the standards. Join the community: Create a free account Support DU (and get rid of ads!): Become a Star Member Latest Breaking News Editorials & Other Articles General Discussion The DU Lounge All Forums Issue Forums Culture Forums Alliance Forums Region Forums Support Forums Help & Search

Apple Users

tiredtoo

(2,949 posts)

7. Thank you all for the advice but,

Reply to tiredtoo (Original post)

Sun Apr 11, 2021, 09:25 PM

Apr 2021

It appears my question was not really correct. I have a spread sheet with data in between 20 and 40 rows. Once all the data is entered I separate it into 4 equal sets. If each set has 10 rows the B2, B9, B16, b23 works fine. however if the number of rows is smaller, a smaller gap between rows would work better. ie B2, B6, B10, B14. The B2 is always the beginning row. It is the B9 to B6 etc. I would like to find a way to do it without manually changing them.
Again thank you for your support. Not sure how to write a visual program in excel. I know macros are in VB but that's all.

Edit history

Please sign in to view edit histories.

Recommendations

0 members have recommended this reply (displayed in chronological order):

7 replies

= new reply since forum marked as read

Highlight:

Changing values in formulas based on calculations [View all] tiredtoo Apr 2021 OP

If there is I would love to know WA-03 Democrat Apr 2021 #1

This message was self-deleted by its author padfun Apr 2021 #2

Yes. There should be a ROWS function. padfun Apr 2021 #3

Try this Shermann Apr 2021 #4

More... padfun Apr 2021 #5

OK, Shermanns answer is probably best for you padfun Apr 2021 #6

Thank you all for the advice but, tiredtoo Apr 2021 #7