insert row on next sheet

L

leonidas

Hi,

I tried to write a macro in Excel VBE for the following procedure, bu
I was not succesfull. Can someone help me? Thanks in advance!

When a row is inserted on the worksheet "Begroting Calc", the rownumbe
of the inserted row should be found in column B on the next workshee
(Activesheet.Next.Select). In column B on that next sheet there ar
formulas. In row 3 column B that is =ROW('Begroting Calc'!K12), in ro
6 column B that is =ROW('Begroting Calc'!K13) and so on.
When the number is found in column B on that next sheet, there shoul
be 3 rows inserted underneath the row where the number is in
 

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

rename cells with a macro 2
Mail Merge Help 1
Array with many cells from a row but not in order or together 11
Find and Replace 6
Eliminate blanks while copy row and transpose 11
Macro to search a text in a cell and copy the row to another set of cell 1
macro to remember sheet 4
Create if partial match then copy and paste data from one cell to another 1

Top