johnnyl

Hi All I have created a COPY button and a CLEAR button on an Excel file. And I have been using it for 3 months without any problems. Suddenly the Error below came out when I click COPY button. CLEAR button no problem. I just want to know, is this error related to my VBA code? I have...

Hi All, My previous post is about copying the worksheet and renaming it based on a specified cell value by using the click button. But still in the same workbook. See below the VBA code:- Sub RectangleBeveled1_Click() Dim ShtName As String ShtName = Range("L1").Value & " " &...

Hi All, I want to set button click to copy and rename worksheet based on specified cell value for example cell K1 = A Press and cell L1 = 16062022 So new worksheet = A Press 16062022 I would like to use the below code but need to modify it a bit. I need someone to help. Sub...

Hi there, Trying to make a table format for lottery "see attachment", where Column A is the numbers that are selected from 1-47 (but only choosing 24 numbers), where in column B thru G are generated all the possible combinations without repeats I've seen other post and really interested how...

Hi All, This entry actually has similarities to my previous entry. Only this time, I tried to use the same formula to get data from multiple criteria. I have amended the formula, but not sure it is correct or not. (Having two criteria is fixed but the other two criteria are variable) Need...

Hi All, Need anyone helps. What's wrong with the below formula? I want to use this formula =IFERROR(INDEX(STORAGE_DATA!$E$3:$E$200,SMALL(IF(1=((--(INV_A6082!$I$1=STORAGE_DATA!$D$3:$D$200))*(--(INV_A6082!$K$1=STORAGE_DATA!$G$3:$G$200))),ROW(STORAGE_DATA!$E$3:$E$200)-4,""),ROW()-4)),"") To...

Hi All, I need help me to edit below formula to copy & paste data from FG_SHIP sheet to SHIPMENT_DATA sheet but need to separate some column. 1. Copy data from column "A3:F" & paste to "A3:F". 2. Copy data from column "G3:G" & paste to "H3:H" Sub RoundedRectangle3_Click() Dim wsFG_SHIP As...

Hi All, Need anyone's help to view this VBA code. I'm not sure what's wrong. Repeated edits, but still came out error #9. Sub datasheet() Application.DisplayAlerts = False Worksheets(Array("FG_Store Bundle", "FG _Ship Bundle")).Delete --> Is there something wrong here ...

Hi All, I need help to edit below formula. I want to autofill the formulas starting with the IFERROR (G2) in the column G until the last row that contains the data in the cells next to it (Column C, D, E & I). Column C,D, E & I is the cells that the IFERROR refers to. Sub fill_all_column()...

Hi All, Anyone can help to confirm below VBA code for above matter? Sub datasheet() Application.DisplayAlerts = False Worksheets(Array("FG_Pack_Bundle", "FG_Store_Bundle", "FG_Ship_Bundle", "FG_Pack_Bag", "FG_Store_Bag", "FG_Ship_Bag")).Delete Application.DisplayAlerts = True...

Hi,. I am trying to rate a combination of numbers based on the criteria I create but there are more than one criterion. Say for example a combination of numbers has 1 low odd, 2 high odds, and 2 high evens I would like to put a ratting in the column next to it like "good" if I think that's a...

HI, So I’m trying to find a more efficient way to achieve this results. I used an if an function to see if the value in a cell is an odd or an even number and is less than ten. If it is it will highlight that cell with the color I choose. I made the column letter absolute so that I can copy the...