Computeractive - Home computing advice in plain English

 

 Simple clear advice in plain English

Search

Search computeractive.co.uk

Go Back   Forums > Readers to the Rescue > Office software
Register Search Today's Posts Mark Forums Read

Closed Thread
 
Thread Tools Display Modes
  #1  
Old 22-01-2013, 11:45
bf1 bf1 is offline
Forum Member
 
Join Date: Jul 2004
Posts: 80
Default Excel - Multiple Table / Sheet Updating

I inherited a database that has several sheets with multiple tables within each sheet.

The numbers in each individual sheet produce a total and then the totals from each sheet are carried forward to another sheet to show a total figure from all the sheets.

The tables represent each year.

I now need to add a column for each table to represent 2013 data.

However, in doing so I presume I will upset all the formulas?

Whilst I know how to add a column I have no experience of formulas.

The other way I thought of doing this was to shift all of the data in each table over to the next column that I could insert 2013 data without upsetting the formula.

But I don't know how to do this either.

Would appreciate any help / suggestions please.
  #2  
Old 22-01-2013, 18:04
mikec's Avatar
mikec mikec is offline
Senior Member
 
Join Date: Nov 2003
Location: Lancashire
Posts: 2,742
Default

I have to make some assumptions on how the tables are constructed.



If the 2012 is on the left as above and the Sheet Total starts with A11, you can just click in Col B and insert a column, then copy the Year Total formula from 2012 col row 11 to the new B11 cell.

If 2012 is on the right, you can just enter 2013 to its right and change the Sheet Total entry to include F11.

If your layout is very different, please be a bit more explicit.

Correction Just noticed the column total should be B4:B10 unless you enter the year as text and not number!

Last edited by mikec; 22-01-2013 at 18:06.
  #3  
Old 24-01-2013, 00:03
bf1 bf1 is offline
Forum Member
 
Join Date: Jul 2004
Posts: 80
Default

Quote:
Originally Posted by mikec View Post
I have to make some assumptions on how the tables are constructed.



If the 2012 is on the left as above and the Sheet Total starts with A11, you can just click in Col B and insert a column, then copy the Year Total formula from 2012 col row 11 to the new B11 cell.

If 2012 is on the right, you can just enter 2013 to its right and change the Sheet Total entry to include F11.

If your layout is very different, please be a bit more explicit.

Correction Just noticed the column total should be B4:B10 unless you enter the year as text and not number!
Mike,

Thanks very much for your help.

I have managed to achieve the required changes following your advice.

Thanks again
  #4  
Old 24-01-2013, 09:14
mikec's Avatar
mikec mikec is offline
Senior Member
 
Join Date: Nov 2003
Location: Lancashire
Posts: 2,742
Default

Good to hear it - well done!
Closed Thread

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off



All times are GMT +1. The time now is 06:37.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.
© Copyright Dennis Publishing Limited licensed by Felden