Excel

[christinewhittle]

Evening all, could someone help/point me in the right direction please?I have an excel workbook with approx. 30 spreadsheets on. 1 tab contains monthly costings and the second tab is a to
Spreadsheet 2 (costings)

Development address	Month (this column has every month for the year and I use a filter)	Rent in	Morg paid	Insurance paid	Tax	Net (rent minus everything else)
10 High street	Dec	100	50	10	10	£30
11 Hill view	Dec	100	50	10	10	30
12 street ad	Dec	100	50	10	10	30

<tbody>
</tbody>

There’s about 300 property addresses over 15 spreadsheets
An adjacent spreadsheet is a total of the above dependant on who owns the property;
spreadsheet 1

Development address	Sept	Oct	Nov	Dec	Jan	feb
10 High street	30
11 Hill view	30
12 street ad	30

<tbody>
</tbody>

My query is that every month I do a copy and paste of every single property’s NET amount from tab 2 into tab 1…. Is there any way I can achieve the same result with less work?

 

[Fennek]

Hi,

yes it is possible, so continue to ask. Some potential helpers might like to see a workbook as an example.

regards