KaZper009
06-23-2008, 03:16 AM
Im trying to create a price list, been doing some study on how to do this whole VBA/Macro thing... which is pretty cool and does everything i want, so i have been told, still in the learning process... however im stuck on a small part that i would love some help with if possible...
I want to be able to click on an item in a list on one worksheet and then possibly hit a button and that will move it to the sheet that compiles a quote of all the items i wish to include in this.
I have managed to get the first code to work to get the info copied to insert onto the sheet as below...
Sub Cpy()
'
' Cpy Macro
'
'
Selection.Copy
ActiveWindow.ScrollWorkbookTabs Position:=xlLast
Sheets("Final Pricing Sheet").Select
Range("B20").Select
ActiveSheet.Paste
End Sub
now my next thing i want to be able to insert a new line under where the above goes... and be able to repeat this above process (like a loop sort or thing) so that the data will be sent to the quoting sheet but on the new line thats inserted...
If this makes any sense...
Please helpon the above if ya can... as soon as... been :banghead: over this for to long now... (Access seems to be able to do this easy... so i found out, but dont have this at work... so gutted... oh and im using Excel 2003)
also wondering if i can have other formulas working in behind all this so it will do a proper quoting tyoe sheet according to the data input in...
Any immediate help would be most appreciated!!!
Thanks Heaps...
Mike
I want to be able to click on an item in a list on one worksheet and then possibly hit a button and that will move it to the sheet that compiles a quote of all the items i wish to include in this.
I have managed to get the first code to work to get the info copied to insert onto the sheet as below...
Sub Cpy()
'
' Cpy Macro
'
'
Selection.Copy
ActiveWindow.ScrollWorkbookTabs Position:=xlLast
Sheets("Final Pricing Sheet").Select
Range("B20").Select
ActiveSheet.Paste
End Sub
now my next thing i want to be able to insert a new line under where the above goes... and be able to repeat this above process (like a loop sort or thing) so that the data will be sent to the quoting sheet but on the new line thats inserted...
If this makes any sense...
Please helpon the above if ya can... as soon as... been :banghead: over this for to long now... (Access seems to be able to do this easy... so i found out, but dont have this at work... so gutted... oh and im using Excel 2003)
also wondering if i can have other formulas working in behind all this so it will do a proper quoting tyoe sheet according to the data input in...
Any immediate help would be most appreciated!!!
Thanks Heaps...
Mike