En cours

Excel Macro Input From Clipboard Data

Hi!! I am in search of an Excel Macro program(s) to accomplish the below. Prospective candidates should have a decent command of the English language and experience in programming Excel macros. Only serious bidders and reasonably priced bids will be considered.

Timely and successful completion of this project can lead to future projects. Your questions and suggestions are welcome. Thanks for your interest and bid.

I need TWO EXCEL MACROS to insert standard name and address informaton. And also, to parse and paste the data I have in the clipboard, into two Excel workbooks.

The FIRST MACRO will write to [url removed, login to view] (see attached) only.

1) If empty, fill in cells B1 (current date) through B9 with name and address information (to be provided)

In the clipboard, I will have a string containing: 'MerchantSKU',’ASIN’,'Quantity','item-condition' Code. (Example 1: 01292013_182,B0002DSQ1A,41,25)

2a) Parse/Paste from the clipboard the 'MerchantSKU' to the next available cell in Column A (beginning at A13).

2b) Parse/Paste from the clipboard the 'Quantity' to the same row cell in Column B.

2c) From clipboard data (Example 2: 01292013_182, B000O78614,47,18)(Example 3: 2014-01-06-104, B000SINSXU,3,9), I have pasted the output that I want to attached files.

------------------------------------------------------------------------------------------------------------

The SECOND MACRO will write to [url removed, login to view] (see attached) as per 1) & 2) below.

1) If empty, fill in cells B1 (current date) through B9 with name and address information (to be provided).

In the clipboard, I will have a string containing: 'MerchantSKU',’ASIN’,'Quantity','item-condition' Code. (Example 1: 01292013_182,B0002DS22A,11,20)

2a) Parse/Paste from the clipboard the 'MerchantSKU' to the next available cell in Column A (beginning at A13).

2b) Parse/Paste from the clipboard the 'Quantity' to the same row cell in Column B.

2c) From clipboard data (Example 2: 01182013_052, B000O98123,4,22)(Example 3: 2014-01-06-119, B000SINEET,2,4). I have pasted the output that I want to the attached files.

The SECOND MACRO will ALSO paste from the clipboard (and also a user prompt) to [url removed, login to view] (see attached) as per 3a – 3i) below.

3a) Parse/Paste from the clipboard the 'MerchantSKU' to the next available cell in Column A.

3b) Parse/Paste from the clipboard the 'ASIN' to the same row cell in Column B.

3c) Print “1” to the same row cell in Column C.

3d) Prompt User for 'price' and enter into the same row cell in column D.

3e) Parse/Paste from the clipboard the 'item condition' code (1,2,3,4, or 11 ) to the same row cell in column G.

3f) Print 'item note' into the same row cell in Column M (depending upon the 'item-condition' code used in 3e) above – Column G). This is a short, three sentence paragraph that differs for each of 5 ‘item-condition’ codes (1,2,3,4,11), and will be provided.

3g) Print string “AMAZON_NA” into the same row cell in Column N.

3h) Print string “A_GEN_TAX” into the same row cell in Column O.

3i) From clipboard data (Example 2: 01182013_052, B000O98123,4,22)(Example 3: 2014-01-06-119, B000SINEET,2,4), I have pasted the output that I want to the attached files.

Compétences : Excel, Visual Basic

Voir plus : programming macros, programming i o with excel, macro programming in excel, g code programming language, 3d print price, 3d print file, data entry form macro excel, copy cell data othe cells macro excel, input macro excel, data input macro excel, find input macro excel, capture input macro excel vba, excel create data input macro, excel data input macro, can create simple data input macro excel 2007, macro excel input data

Concernant l'employeur :
( 140 commentaires ) Lebanon, United States

N° du projet : #8536012

Décerné à :

watersev

Hi there, I have a vast experience in Excel and VBA and would be happy to help you on the project. Best regards, Eugene

55 $ USD en 0 jours
(71 Commentaires)
5.1

31 freelance font une offre moyenne de $144 pour ce travail

zExcel

A proposal has not yet been provided

200 $ USD en 2 jours
(205 Commentaires)
7.2
seaanddream

Hello, my name is Sevinc. I am a 5-star excel and vba coding expert here at freelancer.com. Pls check my profile and feedbacks first to have some idea about the quality of my previous businesses. I had many similar exc Plus

200 $ USD en 3 jours
(133 Commentaires)
6.7
fhasanbd

A proposal has not yet been provided

147 $ USD en 3 jours
(115 Commentaires)
6.3
esalem

Hi, I am VB and GIS developer and well versed in Excel and programming of Excel using VBA or even developing Add-in for Excel using VSTO of .NET. I gave also courses in Excel for UN employees here in Palestine - Gaz Plus

194 $ USD en 6 jours
(11 Commentaires)
6.1
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best regard Plus

83 $ USD en 3 jours
(72 Commentaires)
5.8
dpune

Hi, I have more than 14 years of VBA/Excel exp and I am expert in this kind of work. I have completed more than 250 projects. Please look at the feedback left by my employers to know more about my work. Wai Plus

150 $ USD en 7 jours
(73 Commentaires)
5.9
aarifakhtar

Hi: Please note that I have 100% completion rate and 5-star feedback on all projects (>75 total completed projects). More than 90% of my completed projects are related to Excel and Macros (VBA Script). Please check my Plus

150 $ USD en 3 jours
(70 Commentaires)
6.0
sonarkaushik

Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences and will deliver flawless work. I am very much able to work on this. ***I am ready Plus

194 $ USD en 3 jours
(39 Commentaires)
5.5
AlexandrK1

A proposal has not yet been provided

250 $ USD en 5 jours
(18 Commentaires)
4.8
tomislav1975

HI, please see my profile, contact me if you find me suitable for work. With regards, Tomislav____________________________________________________

250 $ USD en 5 jours
(31 Commentaires)
5.0
slenders13

Dear client, I have a lot of experience with VBA and Excel. Send me a message for more information. Looking forward to work with u. Kind regards, Rens Slenders SlenDATA

100 $ USD en 3 jours
(9 Commentaires)
3.8
surekash7096

I have the expertise in writing excel Macros and can create the macros as per your defined specifications. Ready to start work immediately

155 $ USD en 3 jours
(16 Commentaires)
3.8
lalmansari

A proposal has not yet been provided

155 $ USD en 3 jours
(7 Commentaires)
3.4
aminbros

A proposal has not yet been provided

250 $ USD en 3 jours
(3 Commentaires)
2.8
ithuang2014

A proposal has not yet been provided

178 $ USD en 5 jours
(5 Commentaires)
2.8
zu02

Hi there, I’d like to be considered for your programmer position. I’m an Access/VBA developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Plus

155 $ USD en 3 jours
(1 Commentaire)
2.7
prashushinde9

I want to discuss this project with you further, let me know the best suitable time for you to schedule the meeting, Feel free to message me at any time, i used to be online 14 hrs in a day on this website so probably Plus

250 $ USD en 10 jours
(1 Commentaire)
2.1
serdaryalcin

Hello, What you required is straightforward, and not too hard. However I am questioning why you want it, and if any other solution would be better for your problem. If you can provide more details, maybe I may co Plus

72 $ USD en 3 jours
(3 Commentaires)
2.1
rinabuoy13

hello there, I am experienced vba programmer. I will complete your project with 3 days for USD 100. Looking forward to hearing from you soon.

111 $ USD en 3 jours
(2 Commentaires)
1.4
gsanggara

Hello, in interesting into your project & placed bid for your consideration. I'm excel coder, with 3year+ experienced in excel coder & formulas I am very confident that i will deliver good result as per your requir Plus

75 $ USD en 3 jours
(2 Commentaires)
1.0