Search results for query: *

again thankyou i understand now.

i have this code which works...... With Sheets("introduction").Select Range("I22").Select ActiveCell.Value = "=SUM(R[-3]C[-3]:R[100]C[-3])" End With BUT i want to put it on a different sheet however it give no value ...

are yes of course i will do that. thankyou. thanks for all your help i think iam done

thats great thank u very much for your help electricpete regards rugbyboy123

one more question, just want to add total pipes i.e 1.0,1.1,2.0,2.1,2.2 in a cell will give 5 pipes sum_1 = .Sum(Range("A8:A30")) Sheets("sheet1").Cells(3, 2).Value = PIPE_TOTAL this doesnt seem to work any thoughts??

got question, if i wanted to create a graph for each pipe 0.1 and so on. say the equation was y=x+a and say "a" was a number from a cell i.e (row_num -1,2) which related to that pipe. the x values were 1,2,3,4 so on this is all in a new macro "final table" a graph 1.0 56...

thats no problem at all, yer iv sorted that out, took about 9 hours to do ... but i wont forget it :) no real questions at the moment cheers henneshoe for all your help so far....., you have been reall helpfull kindest regards rugbyboy

hello everybody, I have a value (6) in a cell and i want to look it up in a table 1 4 2 11 3 9 4 6 5 3 i want the program to look up 6 and then give the value 4 in another cell how would one go about this rugbyboy123

sorry iv just looked over it again, i want that in a totally new macro/button so for every 1.0, 1.1 1.2 i wanted it to add two cells then do some maths to it then place into a new cell regards rugbyboy123

yep everything works and i understand where you are coming from . thankyou. if i wnated to add to cells and call it sum_num sum_num = cells ( 6,5).value +cells(6,7) then i want to cal_1 = sum_cell * 100 /1.2 how would i add that in to main function would i need to add to my orignal...

yep it works. thankyou. few more questions to stimulate the old brain 1) the pipe table goes to "sheet2" but the user still has to click on the "sheet2 tab" i think the code is sheet("sheet2").select to automatically take user to that sheet but dont no where to put it in regards to the code...

iv used the macro record button and got With Selection.Validation .Delete .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _ xlBetween, Formula1:="=$N$6:$N$19" .IgnoreBlank = True .InCellDropdown = True .InputTitle = ""...

how do i create a drop down menu containg numbers inside the code, so that it just appears when i click the macro ??

Henneshoe, i want to thankyou so much, that was wicked !!!! just a few more questions 1) for the second table ( when i click "go") how do i transferr it onto a diiferent sheet because for big system it will look a bit messy?? 2)the pipe number starts from 1.1,1.2,1.3 how do i make it start...

first of all thankz for replying, i just want from the user a value ( say 3 systems) presses a button and a table appears on the spreadsheet - step one from the programme take this number and use it for amount of rows needed.column 1 should have all the pipe systems in e.g pipe system 1...

Dear all, i am trying to create a table in excel spreadsheet which the userputs an input data, say 6( or any number ) and from that when they click on a macro button creates the given amount of rows i.e 6 and then the user can add another set of values i.e how many pipe systems ( user inputs...