Annulleret

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, what is macro in excel, to copy, simple macro, rename batch, template workbooks, excel macro row, batch batch excel file, 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, copy cell cell excel macro, excel macro simple, require name, data excel sheet test, simple code save visual basic, copy fields data paste, copy paste rename, copy paste rename file, excel template simple

Om arbejdsgiveren:
( 0 bedømmelser ) Iloilo City, Philippines

Projekt-ID: #6020768

1 freelancer byder i gennemsnit $5 for dette job

madel0619

A proposal has not yet been provided

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