98.8% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
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
Resolved · High Priority · Version 365
Wed 3 Apr 2024, 21:35Delegate 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:17Trainer 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:43Delegate 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:45Trainer 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:45Delegate 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:49Trainer 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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Outlining - Grouping rows or columnsHighlight want you want to group and press ALT + SHIFT + left cursor arrow |
