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

en 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

4 freelance font une offre moyenne de $110 pour ce travail


A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(255 Commentaires)

Bir öneri henüz sağlanmadı

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(142 Commentaires)

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(30 Commentaires)

Bis jetzt wurde noch kein Vorschlag eingegeben

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)