Hello World!
Well, it's been a while since i've been messing with excel VBA and Macros and now I need to develop something thus..
I need the help of the best ones there is!
Basically I have A Data worksheet, with several informations.
Like, factory code, dealer code, Number of the product, mainteneance.. stuff like that.
I need to make a new tab with something like, you input the Factory code, or the Products code and hits this search button.
The final product should give you all the info you need in that tab without having to go in the other ones. Like I can't remember how to make a VBA that looks in every line of a certain range and gives me the info I need.
I've tried to do it and it searches only the first line of every worksheet
Plus, i need to implement the possibility to add a new input, select in what worksheet it should go and press save.
I've done something like it but it was really waaaay back there.. can't remember how I've done it
I know it's a long shot, with a lot of try and error.. But hopefully we will be able to do it!
I will post more info about the worksheet here later. end of the month is a mess for everyone heh.
But I would be glad if you guys helped me out with some "generic" code for that.
Thank you all in advance!
Well, it's been a while since i've been messing with excel VBA and Macros and now I need to develop something thus..
I need the help of the best ones there is!
Basically I have A Data worksheet, with several informations.
Like, factory code, dealer code, Number of the product, mainteneance.. stuff like that.
I need to make a new tab with something like, you input the Factory code, or the Products code and hits this search button.
The final product should give you all the info you need in that tab without having to go in the other ones. Like I can't remember how to make a VBA that looks in every line of a certain range and gives me the info I need.
I've tried to do it and it searches only the first line of every worksheet
Plus, i need to implement the possibility to add a new input, select in what worksheet it should go and press save.
I've done something like it but it was really waaaay back there.. can't remember how I've done it
I know it's a long shot, with a lot of try and error.. But hopefully we will be able to do it!
I will post more info about the worksheet here later. end of the month is a mess for everyone heh.
But I would be glad if you guys helped me out with some "generic" code for that.
Thank you all in advance!