Adding rows to multiple worksheets at once

  • Thread starter Thread starter Karina
  • Start date Start date
K

Karina

I would like to make one worksheet pull from the master worksheet, so that if
a row is added in the master, it is automatically added into the new
worksheet. This does not work by using a formula new B2=Master!B2. I need a
formula that is something like new B2=Master!B1+1 where 1 is not a number but
is the cell below B1 (ie B2 or what used to be B3 etc etc)
 
This needs to be scripted using Visual Basic. Find an Excel programmer who
can do this for you.
 

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

link values from same cell of 20 worksheets into column on one she 3
Excel-Adding rows to master sheet that will be inserted on following worksheets 1
Using a worksheet function to create an unusual cell reference pat 3
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Auto worksheet name? 1
How to use autofilter in excel with formula reference changing 1
Auto worksheet name? 1
convert vlookup formula to link formula 0

Back
Top