alz

  1. K

    To paste data to another sheet by separating several columns

    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...
  2. K

    How to autofill the formulas in the column until the last row

    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()...
  3. K

    How to import multiple csv files into one excel file ?

    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...
  4. K

    How to add a trim formula using VBA code

    Hi Everyone.. I have used the VBA code below to transfer data from another sheet to another sheet before. ___________________________________________________________ Sub RoundedRectangle6_Click() Dim wsIN As Worksheet Dim wsRegister_IN As Worksheet Dim CopyLastRow As Long Dim DestLastRow As...
  5. K

    Copies data from one sheet to another sheet but skip one column

    Hi everyone! Actually I already use below formula to copies data from another sheet to another sheet. That is, by clicking one bevel button, then all the selected data will be pasted to another sheet. Sub Bevel2_Click() Dim wsRegister_IN As Worksheet Dim wsDatabase As Worksheet Dim...
  6. K

    Copies data from one sheet to another sheet but skips one column of data

    Hi everyone! Actually I already use below formula to copies data from another sheet to another sheet. That is, by clicking one bevel button, then all the selected data will be pasted to another sheet. Sub Bevel2_Click() Dim wsRegister_IN As Worksheet Dim wsDatabase As Worksheet Dim...
  7. K

    Formula for matching Data IN and OUT data from another sheet

    Hi All, I would like to match the Data IN and Data OUT in my Database. I have used the formula below to match the data before. =IFERROR(INDEX('Register OUT'!$A$3:$K$2000,MATCH(1,(DataBase!$C$2='Register OUT'!$C$3:$C$2000)*(DataBase!$D$2='Register OUT'!$D$3:$D$2000)*(DataBase!$E$2='Register...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top