I gang

Require a simple macro to copy paste data.

Require a very simple code to do the following.

I have 2 workbooks. "[url removed, login to view]" and "[url removed, login to view]"

[url removed, login to view] has multiple rows with data across 30 columns like Name, Age, Height, Sex, etc etc. That data needs to be pasted to specific cells in template.xlsx.

For eg. Value of Name in row 1 to be pasted in D3, Value of Age to be pasted in F5,.and such predefined cell locations in template. I should be able to define which cell gets pasted where in the template sheet.

The sheet that contains this data ( name, age etc) also has Sr Nos. So this is what i require.

Macro will,

1. Make multiple copies of [url removed, login to view] and rename them as Sr No.xlsx. ([url removed, login to view], [url removed, login to view] and so on based on Sr no.)

In a batch it will be like

copy d:\test\[url removed, login to view] d:\test\[url removed, login to view]

copy d:\test\[url removed, login to view] d:\test\[url removed, login to view]

copy d:\test\[url removed, login to view] d:\test\3.xlsx.... and so on..

2. Open [url removed, login to view]

3. Copy data from first row of [url removed, login to view] and paste it to the [url removed, login to view] (all 30 cells)

4. Save the file, close the file.

5. Next

Færdigheder: Excel, Visual Basic

Se mere: visual age, to copy, simple macro, rename batch, template workbooks, excel macro row, excel 2014 macro, paste data template, batch open excel file, macro cell value, excel macro open file, save data file, excel macro save, simple excel template, excel macro simple, require name, data excel sheet test, copy fields data paste, copy paste rename, copy paste rename file, excel template simple, excel template data paste, open file excel visual, copy paste template, macro copy excel paste

Om arbejdsgiveren:
( 15 bedømmelser ) Banglore, India

Projekt-ID: #6020478

17 freelancere byder i gennemsnit $6/time for dette job

aarifakhtar

Hi: I have done multiple macro projects. Please check my profile to confirm the same. Please let me to know if you are interested.

$5 USD / time
(141 bedømmelser)
6.8
avinav606lx

Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality ou Mere

$10 USD / time
(134 bedømmelser)
6.3
abhinovpankaj

Hi, I am working as software professional in IT industry from last 3 years. I work on VB scripting along with VBA for MS office applications mainly Excel I have done these type of similar projects before. You cou Mere

$6 USD / time
(43 bedømmelser)
5.2
Simplesolz

I have 6+ yrs of experience in excel VBA and have done 130+ projects in several freelancing sites. Have done similar kind of work previously. I can finish this task in 2hrs. Cost Estimate - 8$ x 2hrs = 16$.

$8 USD / time
(27 bedømmelser)
4.1
PG89

Dear Sir, I have already developed macro for such activities. Just need some modification. I can do the total work within 50 USD. Let me know your opinion.

$5 USD / time
(2 bedømmelser)
1.6
hananabbasi

Dear Sir, I am extremely interested to your project and ready to start immediately. Sir if you give me chance I can do this job. I see your project and i do it as your acceptation. I have 2 years experience to work in Mere

$4 USD / time
(3 bedømmelser)
1.0
aticul

Hi, Thanks for your project. I can take 100% confidently your project. I will make you fully satisfy by my work.

$5 USD / time
(4 bedømmelser)
1.8
Sachin9970

A proposal has not yet been provided

$5 USD / time
(0 bedømmelser)
0.0
noorzaman1984

A proposal has not yet been provided

$5 USD / time
(0 bedømmelser)
0.0
sreeramvarma

hi.. i can help you in completing this project. Simple to make it using VBA code. Looking forward for your msg.

$5 USD / time
(0 bedømmelser)
0.0
Rjosh2014

Hi, I have previously worked on complex macros in my workplace related to formatting, formula, if-else conditions etc. I also very well understand the macro coding in Visual Basic. I am keen to work on below requireme Mere

$4 USD / time
(0 bedømmelser)
0.0
safacan

A proposal has not yet been provided

$11 USD / time
(0 bedømmelser)
0.0
elancenali

Hello dear Client, Thanks you for your time to read my proposal. We have vast experience in the Data Converting. We done this job very Easily and Provided you best result this is our promise to our client. We prov Mere

$3 USD / time
(0 bedømmelser)
0.0
sabhijit05

A proposal has not yet been provided

$4 USD / time
(0 bedømmelser)
0.0
nst2014

A proposal has not yet been provided

$5 USD / time
(0 bedømmelser)
0.0
grimmmm123

Hello sir/maam, I bid on your project because I have the skills to do it. I'm a new freelancer here in this site, but I made a lot of projects like this outside this website. I am a fast learner and an honest worker Mere

$3 USD / time
(0 bedømmelser)
0.0
mail2vguna

Hi I have more experience in Macro programming. Looking forward your reply. Thanks and Regards Guna

$10 USD / time
(0 bedømmelser)
0.0