Very Simple Excel Macros / Visual Basic for Applications (VBA)

Imekamilika Ilichapishwa Apr 16, 2014 Kulipwa wakati wa kujifungua
Imekamilika Kulipwa wakati wa kujifungua

I need the VBA codes that do the following:

Cut a range of cells (J1 to AM2) from a file called "[url removed, login to view]"

Paste the data to the same range of cells (J1 to AM2) on the worksheet that I am currently working on.

So the source of the data is fixed (same file path each time)

The destination is whatever worksheet I am currently working on (I want the macro activated from here)

So to recap:

Source: [url removed, login to view]

Cells J1 to AM2

Destination:

Whatever I am working on

Cells J1 to AM2

Excel Visual Basic kwa Vitufe

Kitambulisho cha Mradi: #5815934

Kuhusu mradi

4 mapendekezo Mradi wa mbali Ipo mtandaoni %project.latestActivity_relativeTime|badilisha%

Imetuzwa kwa:

eduardocubel

Hello, I have availability to start your job as soon as possible. Feel free to chat me and see details. If you have any question, please feel free to ask me. Yours Sincerely, Eduardo

£32 GBP kwa siku 1
(Maoni 1)
1.5

4 wafanyakazi huru wanazabuni wastani wa £49 kwa kazi hii

zExcel

Hi, I'll be happy to help you with this code, and can start right away Please feel free to message me if you need to discuss

£55 GBP kwa siku 0
(Maoni 61)
5.9
miyagivw

A proposal has not yet been provided

£66 GBP kwa siku 1
(Maoni 1)
0.9
dragomiranamaria

A proposal has not yet been provided

£44 GBP kwa siku 1
(Maoni 0)
0.0
midhata

A proposal has not yet been provided

£150 GBP kwa siku 3
(Maoni 0)
0.0