Excel workbook; 4 tabs have the same data in each row and column

Resolved · High Priority · Version 365

Wed 3 Apr 2024, 21:35 Delegate Roshni said...

Roshni has attended:
Excel VBA Introduction course
Excel Advanced - Formulas & Functions course

Excel workbook; 4 tabs have the same data in each row and column

Is there an easy way to change formulae, without removing formatting, and adding check totals ie: sum of row 2-5 = row 6, where all the figures are imported into the file. This is across 600 rows.
I need to copy the formule across 4 tabs, and tried by grouping the tabs and adding rows for check total but that didnt work.

thanks

Thu 4 Apr 2024, 08:17 Trainer Jens said...

RE: Excel workbook; 4 tabs have the same data in each row and co

Hi Roshni,

Thank you for the forum question.

I do not understand why you cannot get it to work by grouping the worksheets.

You should be able to do what you want, if you group the worksheets and then insert a row where you want and do the check totals.

Which part doesn't work?

If you are not able to insert rows, it can be another issue.

Try to insert a new row in one worksheet at the time to find out if one or more worksheets having and issue.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Thu 4 Apr 2024, 16:43 Delegate Roshni said...

RE: Excel workbook; 4 tabs have the same data in each row and co

Hey Jens,

I can send you the spreadsheet as it has no figures, you need to have access to our system to be able to import the figures.
So i have been asked to import the information rather than use sums to sum all the subtotals and then include check totals.
I need to do this for 4 tabs.

Is it possible to have your direct email please?

thanks
KR
Roshni

Thu 4 Apr 2024, 16:45 Trainer Jens said...

RE: Excel workbook; 4 tabs have the same data in each row and co

Please send the example to:

info@stl-training.co.uk

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Fri 5 Apr 2024, 14:45 Delegate Roshni said...

RE: Excel workbook; 4 tabs have the same data in each row and co

Hey Jens,

Turns out that this has been fixed, someone else worked on this.
thank you anyway.
I had another question though on Macros.
How do i create a new question?

thanks
KR
Roshni

Tue 16 Apr 2024, 12:49 Trainer Jens said...

RE: Excel workbook; 4 tabs have the same data in each row and co

Hi Roshni,

To ask a new question just click on the URL in the email you received after the course and visit our forum.

Here you will find the option to ask a new question.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector