Macro_repeat in row below

Hello,

I am not very fluent in macros and have a task ahead with causes me a serious headache.

I need to to fill the form using data from 1 row. I have generated simple macro (see below) which works for well. Howerver I have 500 rows that need to respond to the same ‘command’.  Is there any way to do it without recording 500 separate macros?

 

Thank you very much for your help.

 

Sub Macro11()

‘ Macro11 Macro


    ActiveCell.FormulaR1C1 = “=[Notifications_imput.xlsm]Tabelle1!R2C2”
    Range(“G12:K12”).Select
    ActiveCell.FormulaR1C1 = “=[Notifications_imput.xlsm]Tabelle1!R2C3”
    Range(“P12:AH12”).Select
    ActiveCell.FormulaR1C1 = “=[Notifications_imput.xlsm]Tabelle1!R2C4”
    Range(“G15:K15”).Select
    ActiveCell.FormulaR1C1 = “=[Notifications_imput.xlsm]Tabelle1!R2C5”
    Range(“P15:AH16”).Select
    ActiveCell.FormulaR1C1 = “=[Notifications_imput.xlsm]Tabelle1!R2C6”
    Range(“C18:AH20”).Select
    ActiveCell.FormulaR1C1 = “=[Notifications_imput.xlsm]Tabelle1!R2C7”
    Range(“C21”).Select
    Windows(“Notifications_imput.xlsm”).Activate
    Range(“F13”).Select
    Windows(“Generic notification (Uniper).xlsm”).Activate
    Range(“AE7:AH7”).Select
End Sub

By: Alex

3 thoughts on “Macro_repeat in row below

  1. ig

    I blog often and I truly thank you for your content.

    This article has truly peaked my interest. I am going to bookmark your website and keep checking for new information about once a week.

    I opted in for your RSS feed too.

  2. vurtil opmer

    I’m really inspired with your writing talents and also with the structure to your blog. Is this a paid topic or did you customize it your self? Either way keep up the nice high quality writing, it is rare to see a nice weblog like this one today..

Comments are closed.