macro to copy formulas from the above row

[dobracik]

Hi all,

I hope, tha there is somebody who will be able to help me with the following case :-D

I have a spreadsheet, where I will have some firmulas in there ( blue columns). As this workbook wil lbe shared with multiple people and would like to avoid human errors while copy pasting formulas, is there any chance to get the VBA code, that will do the following:

Macro to copy formulas from blue columns and pasted them into next 20 empty rows.

Is this sometng doable?

Thank you :-D

[dobracik]

HI :-)

anybody to help on how to autofill the formulas in next 20 empty rows ( formulsa iwll be in blue columns) by pressing the button?

[dobracik]

Hi guys,

nobody who could help? :-(

[LJMetzger]

Hi dobracik,

Try the following code (also in the attached updated copy of your file) which copies any formulas from Row 2 to the 20 rows after the last row used on Sheet 'Position Change'. Since your spreadsheet did not have any formulas, I put formulas in Columns C, E, and J which reference Sheet 'Data Base' using VLOOKUP(). The code is in Ordinary Code Module ModCopyFormulas.

Please Login or Register  to view this content.

To enable Macros and to Run Macros see the following:
http://office.microsoft.com/en-us/ex...010031071.aspx
http://office.microsoft.com/en-us/ex...010014113.aspx
If help is still needed do a google search for 'youtube excel enable macro' and/or 'youtube excel run macro'.

To access Visual Basic (VBA) see:
http://www.ablebits.com/office-addin...a-macro-excel/
a. Click on any cell in the Excel Spreadsheet (may not be needed).
b. ALT-F11 to get to VBA.
c. CTRL-R to get project explorer (if it isn't already showing).
d. Double Click on a 'Module Name' in 'Project Explorer' to see code for that module.

Lewis