Run Multiple Macro

[getafixkwik]

Hi all.
Is it possible run multiple macro in one workbook?
i wish to add more sheets from original code, 6 to be exact.
i have no knowledge with macro. i try copying original code, add same code and change the sheet name and target data like input2,data2...
but to no avail. Please help and Thanks.

here's the original code. (thanks to the help of Arkadi)

Please Login or Register  to view this content.

[scottiex]

is it that your old 'active sheet" was input and now you just want to run it on whatever the active sheet is becuase there mgiht be quite a few "input" sheets?
if so then maybe just

Please Login or Register  to view this content.

[getafixkwik]

thanks for the quick reply scottiex.
i'm planning of independent sheets with different title and data to input but same format as original.

[rajeshn_in]

Check this one.

Please Login or Register  to view this content.

Is this you want ?

[getafixkwik]

Thanks rajeshn_in.
Actually i have main input sheet to input data and transfer them to the data sheet.
and i also have a button in input sheet that once click, the input sheet's cell turn blank and ready for another input. while the data are transferred into the data sheet.

[rajeshn_in]

Check this one

Please Login or Register  to view this content.

[getafixkwik]

rajeshn_in, your first solution is doing the job (just tried again) but data transferred to data2 is staying in one column and overwriting the last entry.
input and data sheet are tandem. it is these that i want to replicate, just have different name cells.
a little fine tuning perhaps? thanks for your patience.

[rajeshn_in]

Hi getafixkwik,

You want how many input and how many data sheets, one input and 6 data sheets you want ?

[getafixkwik]

hi rajeshn_in . simply put, 6 of the original code in my post (it's a working code, just don't know how to add more). Input sheet to store data in Data sheet. input2 to data2, input3 to data3 and so on. Thanks

[rajeshn_in]

Ok send u shortly

[rajeshn_in]

Please find attachment

Change names in code and Sheet name as you want.

[getafixkwik]

Hi again rajeshn_in, i only use the first file (Separate...), and it works great!
Thank You for your time and help. much appreciated.
Thanks again.