Auto Population

[GDF1983]

Hello,

I am sorry this will look like an essay but the last time I touched Excel in any capacity was back in college and to be fair it was brushed over as hey look =sum(a1+b9) and done job. Anyways I recently been tasked at work with updating some records that they use in Excel and I have been trying to find as much help as I can reading articles etc but this as stumped me

Auto Updating Population

My work spreadsheet is spread over 3 sheets each have their own unique data but share the A and B columns which gives Name and Pay # of the employee. When you inset a row this effect takes place on Sheet 1 but not 2 and 3 , is there any way around this?

I know I could add a row in sheet 2 and 3 manually and then drag the formula down on A1 and B1 to the respective ends but the people I work with are not exactly clued up beyond entering data in the cells.

 

[Joe4]

Welcome to the Board!

hey look =sum(a1+b9)

I always cringe a little when I see people do this! What does "SUM" do? Add. What does "+" do? Add.
You only need one or other, not both. Using both is redundant and totally unnecessary.

You could just use:

=A1+B9

or

=SUM(A1, B9)

The SUM function is really most useful when summing over larger, contiguous ranges. Like if you want to sum all cells from A1 to A50, you would use:

=SUM(A1:A50)

If just summing two cells, simply use:

=A1+B9

I know I could add a row in sheet 2 and 3 manually and then drag the formula down on A1 and B1 to the respective ends but the people I work with are not exactly clued up beyond entering data in the cells.

It sounds like what you are really describing is a relational database scenario. As such, a relational database program like Microsoft Access typically handles this much more elegantly than Excel can (as Excel is not a relational database program).

If you wanted to do it in Excel, your best bets are probably to try one of the following two options:
1. Use VBA to automate those steps being doing manually (i.e. when data is added to one sheet, automatically add it to the other and copy formulas down).
2. Try to use Power Query. I have not used it much myself, but this handles database-type operations in Excel. There is a "Power BI" forum on this board dedicated to questions about the Power BI suite of products, including Power Query,

Hope this helps!