corsasport.co.uk
 

Corsa Sport » Message Board » Off Day » Geek Day » Help needed again ...Trotty can you help


New Topic

New Poll
  Subscribe | Add to Favourites

You are not logged in and may not post or reply to messages. Please log in or create a new account or mail us about fixing an existing one - register@corsasport.co.uk

There are also many more features available when you are logged in such as private messages, buddy list, location services, post search and more.


Author Help needed again ...Trotty can you help
Red_Corsa
Member

Registered: 29th May 02
User status: Offline
20th Mar 03 at 22:53   View User's Profile U2U Member Reply With Quote

on excel how do i get a cell to continuously add to the total of another cell?

eg
WHEN 5 IS TYPED INTO CELL A1
B1 SHOWS THE TOTAL
cell A1 =5
cell B1 =5 (would have formula =sum(a1+b1) but this dont work as when a1 changes so does the total)i want the total to be cummulative.

Now i want to type somthing else in cell A1 and it to add onto the total in B1

eg

A1 =1
B1 =6

i cant find the formula to do this

sum=(add to total or somthing)



[Edited on 20-03-2003 by Red_Corsa]
Red_Corsa
Member

Registered: 29th May 02
User status: Offline
20th Mar 03 at 23:13   View User's Profile U2U Member Reply With Quote

ttt
Trotty
Member

Registered: 22nd Feb 01
Location: Bristol
User status: Offline
20th Mar 03 at 23:19   View User's Profile U2U Member Reply With Quote

Well, you can't have =SUM(A1+B1) cause that'd be a circular reference...

Gimmie a min...

Ian
========
CorsaSport Moderator
South West Organiser
Click here to e-mail me
Click here to sign up for Premium Membership
========
Trotty
Member

Registered: 22nd Feb 01
Location: Bristol
User status: Offline
20th Mar 03 at 23:35   View User's Profile U2U Member Reply With Quote

Ug...

Brain don't wanna work

Has it got to update automatically? I'm just thinking it'd be dead easy to do a lil macro to hold the figure in a variable and clear the cell? Then you could just assign it to a keyboard shortcut and run it - often

Um, can't think of another way at the mo

Ian
========
CorsaSport Moderator
South West Organiser
Click here to e-mail me
Click here to sign up for Premium Membership
========
Red_Corsa
Member

Registered: 29th May 02
User status: Offline
20th Mar 03 at 23:42   View User's Profile U2U Member Reply With Quote

its to do with vb from the other night lol and so yeah i thought it would be simple to just add a number into a cell than add that to a total in another column.

cheers for trying to help
Trotty
Member

Registered: 22nd Feb 01
Location: Bristol
User status: Offline
20th Mar 03 at 23:44   View User's Profile U2U Member Reply With Quote

They're not much help on ScoobyNet either are they

I'd go the macro route personally...

Ian
========
CorsaSport Moderator
South West Organiser
Click here to e-mail me
Click here to sign up for Premium Membership
========
DanielJ
Member

Registered: 21st Nov 01
Location: gwent, south wales
User status: Offline
20th Mar 03 at 23:44   View User's Profile U2U Member Reply With Quote

need 2 add $b$7+$c$7 etc
Trotty
Member

Registered: 22nd Feb 01
Location: Bristol
User status: Offline
20th Mar 03 at 23:51   View User's Profile U2U Member Reply With Quote

Nope Dan, not if you wan it to dynamically update you can't...

Ian
========
CorsaSport Moderator
South West Organiser
Click here to e-mail me
Click here to sign up for Premium Membership
========
DanielJ
Member

Registered: 21st Nov 01
Location: gwent, south wales
User status: Offline
20th Mar 03 at 23:52   View User's Profile U2U Member Reply With Quote

me spreadsheets abit rusty onlything that poped in2 me head
jaffa
Member

Registered: 27th Mar 00
Location: Stoke-on-Trent
User status: Offline
20th Mar 03 at 23:57   View User's Profile U2U Member Reply With Quote

AAAAARRRRGGGGGHHHHHHHHH pissing excel vb
can't avoid vb even on here, been in lectures all day doing excel vb, came home do project vb

and no sorry don't know the answer, but a good book for you to purchase is Reed Jacobson Microsoft Excel 2000 visual basic for applications
Red_Corsa
Member

Registered: 29th May 02
User status: Offline
20th Mar 03 at 23:58   View User's Profile U2U Member Reply With Quote

whats the basic code 4 a macro for this lol, shouldnt be doing my assignments using a car forum website.
Red_Corsa
Member

Registered: 29th May 02
User status: Offline
21st Mar 03 at 00:01   View User's Profile U2U Member Reply With Quote

yep annoying Jaffa, btw your cars v nice, see it in the car park when i park at that end.
jaffa
Member

Registered: 27th Mar 00
Location: Stoke-on-Trent
User status: Offline
21st Mar 03 at 00:02   View User's Profile U2U Member Reply With Quote

you at staffs then?
Red_Corsa
Member

Registered: 29th May 02
User status: Offline
21st Mar 03 at 00:03   View User's Profile U2U Member Reply With Quote

Yeah 1st year
jaffa
Member

Registered: 27th Mar 00
Location: Stoke-on-Trent
User status: Offline
21st Mar 03 at 00:03   View User's Profile U2U Member Reply With Quote

cool doing what? whats your corsa like?
Red_Corsa
Member

Registered: 29th May 02
User status: Offline
21st Mar 03 at 00:06   View User's Profile U2U Member Reply With Quote

lol sold it in october, but cant be arsed get a new name on here,i have a non-modded 306

doin is+com you?

[Edited on 21-03-2003 by Red_Corsa]
jaffa
Member

Registered: 27th Mar 00
Location: Stoke-on-Trent
User status: Offline
21st Mar 03 at 00:07   View User's Profile U2U Member Reply With Quote

info sys accounting

you go up fezy park at all?
Red_Corsa
Member

Registered: 29th May 02
User status: Offline
21st Mar 03 at 00:15   View User's Profile U2U Member Reply With Quote

nahh

 
New Topic

New Poll

  Related Threads Author Forum Replies Views Last Post
How much would u pay for my axe???? (trotty tried to barter me) Steve General Chat 13 1097
18th Mar 03 at 18:23
by Steve106GTi
 
What happened?? Kayleigh General Chat 8 1181
16th Nov 03 at 15:49
by Trotty
 
**byebye saxo, hello corsa(lots n lots of pics,56k?!!!!)** L33 LEG General Chat 61 4019
7th Apr 05 at 23:40
by L33 LEG
 

Corsa Sport » Message Board » Off Day » Geek Day » Help needed again ...Trotty can you help 29 database queries in 0.0124850 seconds