Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: rugbyboy123
  • Order by date
  1. rugbyboy123

    How do i create a table / dynamic array in Excel VBE

    again thankyou i understand now.
  2. rugbyboy123

    How do i create a table / dynamic array in Excel VBE

    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 ...
  3. rugbyboy123

    How do i create a table / dynamic array in Excel VBE

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

    using Vlookup and Hlookup in a spreadsheet

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

    How do i create a table / dynamic array in Excel VBE

    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??
  6. rugbyboy123

    How do i create a table / dynamic array in Excel VBE

    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...
  7. rugbyboy123

    How do i create a table / dynamic array in Excel VBE

    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
  8. rugbyboy123

    using Vlookup and Hlookup in a spreadsheet

    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
  9. rugbyboy123

    How do i create a table / dynamic array in Excel VBE

    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
  10. rugbyboy123

    How do i create a table / dynamic array in Excel VBE

    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...
  11. rugbyboy123

    How do i create a table / dynamic array in Excel VBE

    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...
  12. rugbyboy123

    How do i create a table / dynamic array in Excel VBE

    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 = ""...
  13. rugbyboy123

    How do i create a table / dynamic array in Excel VBE

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

    How do i create a table / dynamic array in Excel VBE

    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...
  15. rugbyboy123

    How do i create a table / dynamic array in Excel VBE

    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...
  16. rugbyboy123

    How do i create a table / dynamic array in Excel VBE

    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...

Part and Inventory Search

Back
Top