kevvukeka
06-11-2013, 09:45 PM
Hi All,
I have developed a macro along with a userform and saved it in a sheet. The macro is based on two sheets "Fruits" and "Icecreams".
Now the data for these two sheets is imported from two different workbooks separately. One for Fruits and one for Ice Creams.
these two workbooks are saved in one folder. Each time I will open the folder. Open the "Fruits workbook". select the "Fruits" sheet and copy data from Columns "A:B" to my workbook->"sheets("Fruits")(My workbook contains the code which I developed). Same with "Icecream workbook".
Later I will refresh my userform which will capture this new data.
Can I get some help in setting some code for this data import from two different workbooks in to "My Workbook". I have attached a sample data.
I have developed a macro along with a userform and saved it in a sheet. The macro is based on two sheets "Fruits" and "Icecreams".
Now the data for these two sheets is imported from two different workbooks separately. One for Fruits and one for Ice Creams.
these two workbooks are saved in one folder. Each time I will open the folder. Open the "Fruits workbook". select the "Fruits" sheet and copy data from Columns "A:B" to my workbook->"sheets("Fruits")(My workbook contains the code which I developed). Same with "Icecream workbook".
Later I will refresh my userform which will capture this new data.
Can I get some help in setting some code for this data import from two different workbooks in to "My Workbook". I have attached a sample data.