Excel, Macro, VBA

HI All, I am explaining what i want in Point wise-

1. I have three input fields named Col, Row and Pitch( I will enter values in these fields)

2. Below this i want a create button

4. On clicking create button, a new excel file should be opened in which I want following type of listing based on what i enter in the input field( say I have entered 2x2 in col X row and 1 in pitch)

5. Then listing in new excel should be something like

Pin Name X Y

A1 0 0 (this value, I mean for Pin number A1, value of X and Y should always be 0,0

A2 0 -1

B1 -1 0

B2 -1 -1

columns X row could be as long as 40x40 or 50x50 or 15x5 and so on, but i don;t want few alphabets in listing like IOQSTU. ( When col x row gets more than 26-IOQSTU(5), that means after col 21 which should be Z1,z2....etc AA1,AA1,AA3 should come again in this also those 5 alphabets should not be present)

Let me know if you need more explanation.

Another Example: (For 3x4 at pitch (Pitch is distance between two pins) od 0.8 this time.

A1 0 0 (this value, I mean for Pin number A1, value of X and Y should always be 0,0

A2 0 -0.8

A3 0 -1.6

A4 0 -2.4

B1 -0.8 0

B2 -0.8 -0.8

B3 -0.8 -1.6

B4 -0.8 --2.4

C1 -1.6 0

C2 -1.6 -0.8

C3 -1.6 -1.6

C4 -1.6 -2.4


Kemahiran: Excel, Visual Basic, Visual Basic untuk Aplikasi, Pemprosesan Data, VB.NET

Lihat lagi: example excel macro vba invoicexls forum, excel macro vba select copy paste internet explorer, excel macro vba functions cut paste, excel macro vba odbc querytable, excel macro vba find word, check add install excel macro vba, excel macro vba freelance job, excel macro vba coding, excel macro vba subdirectories, copy internet explorer paste excel macro vba, create form excel macro vba, excel macro vba import csv text file, excel macro vba rewriting, excel macro vba tree, excel macro vba unicode string, form excel macro vba time clock, import msp project data excel macro vba, sap excel macro vba, excel macro vba word send pdf

Tentang Majikan:
( 0 ulasan ) India

ID Projek: #20901470

Dianugerahkan kepada:


INR 1500 ONLY!!! In just 2 HOURS!! [EXCEL VBA MACRO & FORMULA EXPERT] <<<100% SATISFACTION first, then PAYMENT>>> Sir, please CONTACT with me, I can complete your PROJECT absolutely as per your requirements within LE Lagi

₹1500 INR dalam sehari
(14 Ulasan)

5 pekerja bebas membida secara purata ₹1180 untuk pekerjaan ini


Hi Good Day! A serious freelancer here. I want to help you with this project. I can create you a macro that automatically do this number generator. Please consider my bid. I've done a lot of Reports and Templates usi Lagi

₹1500 INR dalam 2 hari
(29 Ulasan)

I've done job in excel here already. Let me prove that i can do this in max 5 days. I have more than 6 yrs experience in working in excel. Looking forward to work for you!

₹600 INR dalam 5 hari
(1 Ulasan)

iam good skilld in visual basic n .net and i also has good knowledge in excl and i can give the best results to your project

₹1050 INR dalam 7 hari
(0 Ulasan)

Hi. I completely understood the Matrix table you want as output. Let me write vba macro code this task. As I am full time freelancer I can complete this task as soon as possible hours within a day... Thanks, Ram...

₹1250 INR dalam sehari
(0 Ulasan)