The code below shows:
ColA
Qty1
Qty2
Qty3
can I modify it to show
ColA -ColB-ColC
Qty1
------Qty2
-----------Qty3
Please Login or Register to view this content.
The code below shows:
ColA-ColB-ColC
Qty1-Qty2-Qty3
can I modify it to show:
ColA -ColB-ColC
Qty1
------Qty2
-----------Qty3
Please Login or Register to view this content.
Hello Pukka83,
Here are 2 macros to do what you want. Change the variable values in red to match what you need.
Please Login or Register to view this content.Sincerely,Please Login or Register to view this content.
Leith Ross
thank you so much! I couldn't get it the way I want the code to be...
do you mind to help me take a look at my code? It's in the nvT Sheet.
I'm getting this:
http://www.geocities.com/gjfeng/no.bmp
the desired outcome is:
http://www.geocities.com/gjfeng/yes.bmp
The part which controls the qty value is:
qty = Worksheets("db").Cells(intRow, 8).Value
'Sheets("nvT").Range("c" & Columns.Count).End(xlUp)(2).Resize(, 1).Value = qty
Worksheets("nvT").Range("IV7", Worksheets("nvT").Cells(7, Columns.Count).End(xlToLeft))(3).Value = qty
link: http://www.geocities.com/gjfeng/protoV2.xls
Please Login or Register to view this content.
Last edited by Pukka83; 05-26-2008 at 02:04 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks