corsasport.co.uk
  Not logged in [Login - Register]  
You Are Not Registered Or Not Logged In  

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 1153
18th Mar 03 at 18:23
by Steve106GTi		  
What happened?? Kayleigh General Chat 8 1231
16th Nov 03 at 15:49
by Trotty		  
**byebye saxo, hello corsa(lots n lots of pics,56k?!!!!)** L33 LEG General Chat 61 4273
7th Apr 05 at 23:40
by L33 LEG		  

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