Create a macro that will continuously copy multiple sheets into one sheet

$30-250 USD

Скасований

Опублікований

almost 11 years ago

$30-250 USD

Оплачується при отриманні

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.

Data Entry

Data Processing

Excel

ID проекту: 4751365

Про проект

16 пропозицій(-ї)

Дистанційний проект

Активність 11 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни

Отримайте гроші за свою роботу

Опишіть свою пропозицію

Реєстрація та подання заявок у проекти є безкоштовними

16 фрілансерів(-и) готові виконати цю роботу у середньому за $103 USD

@jeweljitu

Kindly Please check my comments, past feedback in the following message board, we look forward to your response.

$178 USD за 4 дні(-в)

4,9

(179 відгуки(-ів))

6,5

@Teloquence

Consider it done. Check your PM for my bid details.

$111 USD за 1 день

5,0

(73 відгуки(-ів))

5,6

@nagybatonyi

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

$111 USD за 3 дні(-в)

4,9

(48 відгуки(-ів))

5,6

@mrbrave

It seems a quick task for a Excel macro expert.....Lets discuss the procedure in detail and start off......I can complete Macro within few hours.

$64 USD за 1 день

5,0

(92 відгуки(-ів))

5,5

@pkcyber

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

$150 USD за 3 дні(-в)

5,0

(21 відгуки(-ів))

5,4

@deepbluetech

I can take on the job. Let me know.

$111 USD за 3 дні(-в)

5,0

(72 відгуки(-ів))

5,2

@seaanddream

Hello; I read your project, and got the point exactly... your 5-star excel & vba coding expert is ready to help you...regards,

$80 USD за 3 дні(-в)

5,0

(38 відгуки(-ів))

5,1

@jaylancer43

Excel VBA Expert. Please check PM for details. Thanks.

$66 USD за 3 дні(-в)

5,0

(14 відгуки(-ів))

3,7

@hgk

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

$60 USD за 5 дні(-в)

4,7

(7 відгуки(-ів))

2,7

@sibeng

Can help you with this

$172 USD за 3 дні(-в)

0,0

(0 відгуки(-ів))

0,0

@Faraoon

Ready to start this job for you quickly and with high quality. Faraoon

$70 USD за 1 день

0,0

(0 відгуки(-ів))

0,0

@AJStechnologies

I can easily do that job for you.

$100 USD за 3 дні(-в)

0,0

(0 відгуки(-ів))

0,0

@ashishagarwal77

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.

$111 USD за 3 дні(-в)

0,0

(0 відгуки(-ів))

0,0

@mmbertasi

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.

$60 USD за 1 день

0,0

(0 відгуки(-ів))

0,0

@ExcelDictionary

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

$55 USD за 1 день