Data Organization and Excel Merging
Budget: ₹600 – ₹1,500 INR
Need help with the following problem statements.
1. I get CV's on LinkedIn.com, I want to move the relevant details of CV into one simple spreadsheet. What would be relevant details? Name, Phone number, Email address, Current designation & Last worked company name. Also the spreadsheet on which the data will come will have a tab for send email , after clicking it would directly send an email for the 3-4 templates which I have
2. I want to build a macro which will take relevant data from multiple excel files. The format of all the source excel files will be same. I will place these multiple excel files into a single folder. Each time I add a new excel file into that folder, the new relevant details will get added in row in a master excel or spreadsheet.
1. I get CV's on LinkedIn.com, I want to move the relevant details of CV into one simple spreadsheet. What would be relevant details? Name, Phone number, Email address, Current designation & Last worked company name. Also the spreadsheet on which the data will come will have a tab for send email , after clicking it would directly send an email for the 3-4 templates which I have
2. I want to build a macro which will take relevant data from multiple excel files. The format of all the source excel files will be same. I will place these multiple excel files into a single folder. Each time I add a new excel file into that folder, the new relevant details will get added in row in a master excel or spreadsheet.