Lukket

Do some Excel Work

Hi

I need a VBA macro to be run when I open a formatted file (attached) which can have between 1 and 1000 rows. Actions:

1-delete column A

(note the column name below are the current name in the sample file)

2-insert a column between I and J; Title of the column is Total; formula to be inserted in all cells of this new column: sum of H + I cells

3-insert a column between K and L; Title of the column is Total; formula to be inserted in all cells of this new column: sum of J + K cells

4-insert a column between M and N; Title of the column is Total; formula to be inserted in all cells of this new column: sum of L + M cells

5-insert a column between O and P; Title of the column is Total; formula to be inserted in all cells of this new column: sum of N +O cells

6-insert a column between Q and R; Title of the column is Total; formula to be inserted in all cells of this new column: sum of P + Q cells

7-insert a column between S and T; Title of the column is Total; formula to be inserted in all cells of this new column: sum of R + S cells

Evner: Databehandling, Excel, Visual Basic

Se mere: formula o macro in excel, excel vba macro, insert macro excel, data processing vba, excel vba processing, excel can open file, excel 2014 macro, vba data processing, excel vba macro file, excel work processing, macro formula, excel open formula, excel sample file, excel macro open file, delete rows excel macro, excel delete, vba processing, cells insert, vba macro excel, excel vba formula

Om arbejdsgiveren:
( 0 bedømmelser ) Malaysia

Projekt ID: #6611208

44 freelancere byder i gennemsnit €23 på dette job

dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 215 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive Flere

€34 EUR in 2 dage
(50 bedømmelser)
5.6
customizedata

Think it already done. Please provide the sample sheet so that i could start the work and deliver in no time

€16 EUR på 1 dag
(59 bedømmelser)
5.5
expertatwork

A proposal has not yet been provided

€19 EUR in 0 dage
(97 bedømmelser)
5.4
JonNxt

Hi there, I've been working with Excel since before '98 and I've been using all possible versions of it. I have years of experience working with macros and writing / debugging VBA code. You may check my portfolio Flere

€30 EUR på 1 dag
(33 bedømmelser)
4.8
gperete

Software developer since 2000, specializing in Visual Basic, Crystal Reports, SQL Server, and VBA for MS Office

€25 EUR på 1 dag
(8 bedømmelser)
3.7
vsprybhanu

Hi, Experienced VBA, VB6 and VB.Net Programmer. Expertise in Data Entry, Data Processing, Excel and Programming. Read and understood your project description. I've done many similar jobs. Please check Flere

€24 EUR på 1 dag
(17 bedømmelser)
3.6
nmcdorman

Hello, I am a Expert VBA Developer. I write code for my company utilizing VBA to import/export data from multiple databases and sources and build Reports/Automate Tasks/Analyze Data/Store Data. Utilizing: .txt, .csv., Flere

€8 EUR in 0 dage
(1 bedømmelse)
3.6
Mufaddalsaifee

Hi, Greetings for the day. I would be able to start working on it right now. I have 3+ years of experience in VBA. You can trust me and for my past experience you can check feedback on my profile and i can s Flere

€23 EUR på 1 dag
(11 bedømmelser)
3.4
carstensal

Hi I've completed a sample macro which will complete your requirements. Note this is only a sample, but could be set up to run when opening a document as well or to run on a different document. The sample can be v Flere

€20 EUR in 0 dage
(2 bedømmelser)
3.3
Wasif966

Hi. we will be lowest bider Lets Start. 100% job setisfection....Work on very cheap rates...payment after work.. Would you like to discuss more?

€8 EUR på 1 dag
(5 bedømmelser)
3.1
prabakarm23

Greetings for the Day!!! I have 5 years of experience in Excel Macro creation with SAP, Internet explorer, PDF & Text files, MS Access and SQL Server databases. Hope if awarded with this project with 100% satisfa Flere

€14 EUR in 0 dage
(5 bedømmelser)
2.4
renesontiongson

Hi! I am BS Accountancy major in Accounting and excel automation is my masterpiece. If you are serious enough and need help, feel free to message me with your actual data. Thank you.

€30 EUR in 0 dage
(4 bedømmelser)
2.3
solutionland2014

hi I'm an IT student with good knowledge in excel, I can help you to do this. I have enough motivation to do this, because I'm new here and need to make reputation. If you consider me, I will do best for you.

€19 EUR på 1 dag
(5 bedømmelser)
2.0
ijam1301

HI. I have years of experience in EXCEL and VBA development. Currently I'm working in a reporting team for a multinational company. Doing VBA is my passion and I have would like to be given a chance to do this projects Flere

€23 EUR på 1 dag
(2 bedømmelser)
1.2
macroPOL

Nie złożono jeszcze oferty.

€30 EUR in 3 dage
(2 bedømmelser)
1.1
vishalkaushikmca

A proposal has not yet been provided

€25 EUR på 1 dag
(1 bedømmelse)
0.0
kingselasi

I understand this project and I believe I have the required skills to give you an excellent work. I have an enormous experience in this kind of projects. I am always available for further discussions. Thank you.

€23 EUR på 1 dag
(1 bedømmelse)
0.0
soloaplus

WE ARE A TEAM OF ICT PROFESSIONALS AND WISH TO APPLY FOR THIS CONTRACT. COUNT THIS JOB DONE AND COMPLET IS AWARDED TO MY TEAM.

€19 EUR på 1 dag
(0 bedømmelser)
0.0
nmitools

At my everyday job as an civil engineer creating VBAs is usual activity. If You are interested in more I am open to talk about it. Even for a some kind of training if its applicable to You.

€14 EUR på 1 dag
(0 bedømmelser)
0.0
educar789

La propuesta todavía no ha sido proveída

€8 EUR på 1 dag
(0 bedømmelser)
0.0