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, 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:
( 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