I have an excel sheet to collect nearly 3000 data from people.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
These data’s are providing by different people. Say one person will give 50 data and other one will give 150 data etc.
<o></o>
Each question is assigned to a person to give data.
My excel sheet looks like this
<o></o>
A B C
Question Data Responsible
Product in Unit A Bob
Product in Unit B Brian
No of Total Employees Chuck
Hourly contract rate Bob
<o></o>
I send the file to 20 people and all answered their part and send back to me.
Now I have 20 similar files with partially filled data.
I am looking for a VBA macro to compile the data from all sheets to one master file.
Appreciate the help anybody can extend.
Regards
Kumar
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
These data’s are providing by different people. Say one person will give 50 data and other one will give 150 data etc.
<o></o>
Each question is assigned to a person to give data.
My excel sheet looks like this
<o></o>
A B C
Question Data Responsible
Product in Unit A Bob
Product in Unit B Brian
No of Total Employees Chuck
Hourly contract rate Bob
<o></o>
I send the file to 20 people and all answered their part and send back to me.
Now I have 20 similar files with partially filled data.
I am looking for a VBA macro to compile the data from all sheets to one master file.
Appreciate the help anybody can extend.
Regards
Kumar