En cours

Excel Macro - Format Content - MUST START IMMEDIATELY - FAST JOB

Please see the attached Macro. This is working for us, but I’d like it to be modified in the following ways:

• Determine the appropriate range of cells (last column with populated Product ID and last row with Kit ID)

o (In the attached Example, the array would be A1:O6434)

o This range will always be different, and I’d like it to automatically detect the range.

o Right now this is done in Row 19 of the macro where it asks for a range of cells.

o If it’s not possible to automatically detect, then I’d like a prompt box to ask me to select the ending cell (A1 will always be the original cell)

o (This will be the array of data for all of the following steps)

• In the cells regarding product quantities, replace blank cells with “0”

o In the original grid that they send, they include blank cells instead of a 0 quantity. Right now I am highlighting the array and using a CTRL+G function to replace the blanks with 0

• Replace any spaces in the Kit Names of Column A (so “Generation 1” becomes “Generation_1”)

• Generate the Kit ID by inserting a column between A and B and CONCATENATE Column A, “_”, with all of the following numbers in the applicable columns/cells

o So the final cell value would look like “Generation_1_25552001010000”

o Note the underscore between the Kit ID and the numbers

• Remove any Duplicate Kit ID rows

• When I run the Macro, instead of it asking me for the cell number that I’d like to place the new list, I’d like for the macro to automatically create a new sheet and place it in A1 with the following headers:

o A1 = Kit_ID

o B1 = Product_ID

o C1 = Product_QTY

o (All of the data from the macro underneath these columns)

• I only want the result to include rows where product quantity > 0

Compétences : Excel, VB.NET, Visual Basic

Voir plus : when to look for a new job, names generation, wordpress designer job start immediately, write macro format data excel, excel macro find content cell, excel macro cell content copy, searching cell content excel macro, online job start immediately, quick fast job, macro search website based cell content excel, start myspace layout site content management system, excel macro format phone numbers

Concernant l'employeur :
( 31 commentaires ) Covington, United States

N° du projet : #8495527

Décerné à :

bossumd

Ready to do the job quickly and neatly. Formulas of any complexity, VBA scripts, interactive worksheets. MS Office 2003, 2007, 2011 (for MacOS), 2013.

35 $ USD en 1 jour
(1 Commentaire)
0.0

5 freelance ont fait une offre moyenne de 95 $ pour ce travail

zExcel

A proposal has not yet been provided

175 $ USD en 0 jours
(205 Commentaires)
7.2
rajafaizan

I am very interested in working online for you. I am interested in long term work. I have had 5+ years exp. in Computers, MS word, MS excel, Quickbooks, Office Management , PDF, Google spreadsheet Powerpoint, Vba and t Plus

74 $ USD en 1 jour
(20 Commentaires)
4.2
someka

Bir öneri henüz sağlanmadı

69 $ USD en 1 jour
(17 Commentaires)
3.7
abir917

Hi, I am a full-time worker with Vast Knowledge and Experiences of- Web Research, Ms-Office, Web Designe, Graphics Designe, Logo Designe, Data collecting, Data entry, Advertising, Data mining, Translation , Typing i Plus

66 $ USD en 1 jour
(3 Commentaires)
1.8
J1Eilers

Bis jetzt wurde noch kein Vorschlag eingegeben

120 $ USD en 2 jours
(0 Commentaires)
0.0