Create a macro that will continuously copy multiple sheets into one sheet
$30-250 USD
Cancelado
Publicado hace más de 10 años
$30-250 USD
Pagado a la entrega
I have an excel file with multiple (more than 20) spreadsheets, each spreadsheet contains some data. I need to create a macro that will copy three columns that are located at different locations from each spreadsheet and paste the data from the three columns into another summary spreadsheet.
The macro must be able to update the summary spreadsheet when I make changes in the multiple (more than 20) spreadsheets and also copy three columns when I add a new sheet.
Such jobs are my daily practice. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. Regards
Hi, I will give u an appliaction which will take the excel file paths and do all of stuff automatically.
Advantage of this is, it will work on that system also where there is no excel installed.
See my similar applications links in your PMB
Hi,
I have over 8yrs of experience working with excel macros and formulas. I would like to take up this project.
Please provide me some sample data so we can get started.
thanks & regards
Efficient & dedicated freelancer, always provide a timely & quality deliverables, proficient in excel. Have delivered such projects in past & assure you quality deliverable. I am 13+ years of experience in this field please rest assured you will be leaving it in safe hands.
I can take of this immediately and have extensive experience with excel in nearly every IT job I have held. My bid is relatively low as I am new to Freelancer and am looking to get some work to develop a reputation.
Greetings for the United Kingdom!
Hi Macartria, I'm a newbie to freelancer and looking to start on my first project. I'd love to get cracking on your project asap and am happy to say I've got the necessary VBA macro programming skills to do everything that you have requested in your brief.
I will aim to create a macro which detects the number of sheets within the workbook and if this changes will automatically repopulate the 'Summary Sheet' which will filter just for the 3 columns that you have asked for.
I'm happy to turn this around within 24 hours if you let me know asap that you would like my services and that the spreadsheets are nicely laid out. Feel free to send me a copy of your spreadsheet via direct message if you wish me to glance my eyes over it and provide any advice.
Look forward to hearing from you.
Kindest Regards
ExcelDictionary