excel workbook tabs

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel workbook; 4 tabs have the same data in each row and column

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

resolvedResolved · High Priority · Version 365

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

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

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

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

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

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


 

Excel tip:

Outlining - Grouping rows or columns

Highlight want you want to group and press ALT + SHIFT + left cursor arrow

View all Excel hints and tips


Server loaded in 0.06 secs.