Automatic adding of rows based on different sheet

[Todrianth]

Hi,

I am trying to make some sort of automation that does this:

Sheet 1

Column with text	Calculation 1	Calculation 2
Row 1 (has information according to a row in sheet 2 BUT, when I add another row in sheet 2 it automatically adds another row to this first table in sheet 1 copying all the formulas of this Row 1 to Row 2 below)	formula	formula
Row 2 (automatically added if Row 2 exists in sheet 2)	formula (copied from Row 1)	formula (copied from Row 1)
Row 3 (automatically added if Row 3 exists in sheet 2)	formula (copied from Row 1)	formula (copied from Row 1)

Sheet 2

Row 1 information

Row 2 information

Row 3 information

Main idea is that, a person should work only in sheet 2 in order for his table in sheet 1 to be made, without having to manually copy/drag all the formulas for all the columns that table in sheet 1 might have, therefore improving speed and reducing error. Other sugestions are welcomed as-well.

Thanks !

[Bernie Deitrick]

Right-click the sheet tab of Sheet2, select View Code, and paste this code into the window that appears. Then save the file as a macro-enabled .xlsm

Please Login or Register  to view this content.

[Todrianth]

Do I need to modify something in the code because for me is not working. (tried also with new workbook)

[Bernie Deitrick]

It may be that you have a large usedrange already. So let's try using just column A:

Please Login or Register  to view this content.

[Todrianth]

It might be because I'm a total noob when it come to macros. The thing I did was to open excel (run, excel), view code on "Sheet 2", paste your code, save (in visual basic application, small discket button), and then select Excel Macro-Enabled Workbook as extension. Then I try to write something in sheet 2/column A and nothing happens in sheet 1. I have Excel Home and Business 2010.

[Bernie Deitrick]

The code is written to go onto sheet2 not sheet1 - that was how I interpreted your description If that is different change all the sheet1 to sheet2 and vice versa