Excel "Offsetting" Rows

  • Thread starter Thread starter JohnRid64
  • Start date Start date
J

JohnRid64

I have a formula that reveals a value for the cell B2 which comes under an id
number 1. If, for example, if that value were 6, I need to add 6 rows to be
included under the id number 1. Is there a formula which can do this, as it
would save a lot of manual filling in of data? I have tried to come up with a
solution using OFFSET, but to no avail.
Thanks in Advance.
 
If you need to add 6 rows (insertion), you will need code.
If you are simply designating an area where the rows of data should be
placed, Offset would likely be used.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

OFFSET Formula 5
OFFSET PROBLEM 2
MACRO COLUMNS, SKIP ROWS 6
Offsetting the vlookup function 4
External reference for Offset formula 2
Offset in Conditional Formatting? 2
Count help with numbering Rows? 2
Smart way to concatenate into B1 all cells below until new info in Column A 1

Back
Top