Excel to Word copying macro

£10-20 GBP

Opravljeno

Objavljeno

pred več kot 5 leti

£10-20 GBP

Plačilo ob dostavi

Hi, What I need is probably really simple but I can’t figure it out. I have a bunch of tables in excel that I want to copy into word; with the appearance matching how it would look if I did the copy and paste manually. Each table is on its own worksheet and is a named range (local name... name is same on each sheet), each sheet also contains a named cell (again... local name... same on each sheet) with the title of the table. I want the macro to paste the tables into word with the table title separating them, captioned as a table in word. Ie the macro would do the same as if I: 1) insert a caption with the ‘table’ label 2) the append with the title copied from the value of the title cell 3) copy and paste the named range from the worksheet 4) change the table property to be centrally aligned on the page Rinse and repeat with the data from the next worksheet.

Excel

Visual Basic

Visual Basic for Apps

Word

ID projekta: 18122184

Več o projektu

8 ponudb

Projekt na daljavo

Aktivno pred 5 leti

Želite zaslužiti?

E-naslov

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir

Prejmite plačilo za svoje delo

Povzetek predloga

Registracija in oddajanje ponudb sta brezplačna

Dodeljeno:

@beltran0404

Hello, I am Luis from Venezuela and it will be my pleasure to help you with this project. I can do your Excel to Word document according to your requirements. Please contact me by chat and then we could discuss further details about your project! Kind regards, Luis Romero

£20 GBP v 1 dnevu

5,0

(192 ocen)

6,1

8 freelancerjev je oddalo ponudbo s povprečno vrednostjo £16 GBP za to delo

@engrranakaleem21

Hello, I have already gone through the details from you. I think it is the best suited for me and you will have got an excellent feedback. I am available from now on. I ensure you i will provide you a better quality work. So please call me an invitation. Regards, Rana k.

£10 GBP v 0 dnevu

4,9

(49 ocen)

5,5

@egafiori

My name is Esteban, I'm an industrial engineer and Excel/VBA Expert. I'm new freelance,You can see some of my experiences in my profile. I could also help in economic analysis and evaluations, based on regression studies and statistical estimates. I would love to help you in your project and that you can help me earn more points!!

£10 GBP v 1 dnevu

4,9

(27 ocen)

4,2

@anisheco

Hi, I have 10+ years of experience in report/process automation using MS Excel with VBA. I read the job description and understand the requirements. We can create bookmarks in the word document, and create a control panel in excel to take named range A to bookmark A and paste it. I should be able to deliver this within a day. Request you to consider my proposal and let me know if you have any questions. Regards, Anish

£20 GBP v 1 dnevu

5,0

(3 ocen)

3,3

@eternalvs

Hello, My middle name is "macro" :) I do this type of work all day everyday, and have done so for 10+ years. I am confident I can write a macro to copy your excel tables to word and format them as you have laid out in your description. It will be done today, tomorrow at the latest. I look forward to hearing back from you and getting started! Thank you, -Eric.

£20 GBP v 0 dnevu

5,0

(5 ocen)

2,8

@wafaaalia

1day 18$

£18 GBP v 1 dnevu

0,0

(0 ocen)

0,0

@Hardeeek

"Dear Next Employer We will give you the best result by uses my Past Experience and excellent academic skills on your project. You cam chat with me and let's get started, I Am ready to show you some samples of similar projects I've completed. Thanks"

£10 GBP v 1 dnevu