I gang

Macro in excel with shapes

Hi,

I need to copy the text from shapes within some ranges of a sheet in excel and paste in other ranges.

There are 9 ranges that will be filled with shapes and 9 ranges to copy the text from those shapes

The macro should search for each shapes within each range and copy to a specified range.

The shapes will be copied from "Canvas" sheet to "Plan" sheet.

Please be sure to understand this:

Each post-it placed on range R3 to U21 or Clients represent a type and each type is defined by the color of post-it in the other ranges.

The type of each post-it text should appear on column C of the ranges of sheet "Plan".

I created a sheet named "For macro creation" giving the ranges and I'm attaching two files (one in blank and one as it should appear).

In the excel attached we already have post-its placed but we should have the possibility create one only drag and drop the four types on right site to the ranges and the macro should work.

All informations are already here. Please read carefully.

Færdigheder: Excel, Visual Basic

Se mere: excel macro shapes, excel copy shapes, excel macro shapes within range, we excel, macro, macro excel, macro + excel, excel type work, copy informations, copy excel, drag drop excel, canvas drag, visual basic excel post, range macro excel, sheet excel visual basic, visual read files, macro creation, excel text column, creation excel, excel column copy, excel create macro, type excel sheet, excel drop, excel create, color plan

Om arbejdsgiveren:
( 13 bedømmelser ) Rio de Janeiro, Brazil

Projekt-ID: #942548

Tildelt til:

vserv

Pls see your messages. Thanks

$50 USD in 3 dage
(62 bedømmelser)
5.7

17 freelancers are bidding on average $70 for this job

fedalal2

Hi, I have more 10 years experience in MS Excel and Office automation, so I'm realy GURU in this. I can help you with this project. Best Regards, Alex

$40 USD på 1 dag
(32 bedømmelser)
5.5
mrbrave

See sample in PMB please....

$100 USD in 2 dage
(75 bedømmelser)
5.4
djucuti

Hi, please check PM

$90 USD in 5 dage
(19 bedømmelser)
4.7
piyushdpatel

Hi This is Piyush Patel I have 6 yrs of Exp in VB6,VB.net,SQL and MsAccess. I have developed many applications in VB6,VB.NET. Please Check My PM

$80 USD på 1 dag
(10 bedømmelser)
4.0
muthumuni

(((((Your Search End Here!!!))))) {{{{{{Just Do It}}}}}

$30 USD in 3 dage
(11 bedømmelser)
3.8
manishadk

please view PMB for details.

$100 USD in 2 dage
(10 bedømmelser)
3.6
rajkavikumar

Hello, Please check PMB I have started working on your project

$30 USD på 1 dag
(3 bedømmelser)
3.2
VenturSum

Please see PM, 15 years building Excel applications - I've done this application several times.

$52 USD på 1 dag
(1 bedømmelse)
3.1
Abikris

Hi, Check PMB. Kris

$50 USD in 0 dage
(4 bedømmelser)
2.1
emce75

Hi, i'm almost did it already :) please check your PM attachement. Regards, Mariusz

$50 USD på 1 dag
(1 bedømmelse)
1.8
szhomestudio

This project is OK for you. Please check the PM.

$50 USD in 0 dage
(1 bedømmelse)
1.4
muhammadnaveel

we have a very good experinece of macro.

$40 USD på 1 dag
(0 bedømmelser)
0.0
objectcreator

ready to start to work

$100 USD in 5 dage
(0 bedømmelser)
0.0
errahulgoel

Hi. Please refer to PMB.

$100 USD in 3 dage
(0 bedømmelser)
0.0
sathish98431

i am intrested in this prtoject

$30 USD in 5 dage
(0 bedømmelser)
0.0
VisualBasic2011

I am interesting .

$120 USD in 15 dage
(0 bedømmelser)
0.0
summitinnovation

Please Check PMB

$100 USD in 3 dage
(0 bedømmelser)
0.0