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 : look new job, names generation, online job start immediately, quick fast job

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