Search results

anyone can help?

Hi ALL, I need some help to create a macro to compare quantities of 2 worksheets and then create a new worksheet showing quantity change. See attached sample excel file and work step when I done this exercise manually. The macro will help reduce time spent and possible error in manual...

Thanks. That's what I am doing now.

Hi Charlesdh, The reason that I ask is that aside from P-List & A-List, their are other sheets that I want to exclude. Thank you.

Hi charlesdh, Your code is working for the my desired result but i like to change the code to copy all worksheets (starts with "data") If ws.Name <> "P-List" And ws.Name <> "A-List" Then Thank you.

Hi vletm, Yes, it is another part of the of the SelectedSum workbook. I am not well versed with VBA so I try to break into manageable parts for me to understand VBA. Updated version I added prefix (data_) to all worksheet need copy values from with my limited vba coding skills, i've created...

Anyone can help on this.

Thank you vletm, I am not good in VBA, just browsing some sample vba codes and tweak to suit my needs. Your help is much appreciated.

Hi all, I would like to consolidate the following data ranges using VBA. 1. copy range H4:J(last row) of all sheets from Jan-19 to the last sheets. Number of worksheets may be more than 12. All datas copied will be stored on sheet(P-List) and remove duplicate based on SKU ID column. (see...

Hi vletm, Your code is what I need, just a minor addition to get dynamically the last column and row. For b = 4 To 61 <-- can be set to last column? For x = 11 To 24 <-- can be set to last row? Thank very much. rxk --- I found the code to fine the last row and column: 'Finds the last...

Hi All, HAPPY NEW YEAR!!! I need some assistance how to make VBA. Sum range K4:X4 if corresponding cell of range K2:X2 is true (checkbox value). I have formulas at range B4:B61. See attached workbook.

Hi SirJ7, I have a similar issue with pat6x but on different column criteria. I tried using your code but I don't understand part of it, it has error on the With Application.WorksheetFunction syntax, can you please explain how it works? I also added sample files Sub VlookTrans1() '...