#vba #excel #pleasehelp

  1. K

    How to Highlight Cell After match Both data ???

  2. K

    HOW TO LOCK COLUMNS ??? (we need Lock Highlight Columns)

    @ HOW TO LOCK COLUMNS ??? I try Column " A" & "B" FIX & Lock ....... This "HSN CODE " IS EVERY TIME FIX & SAME IN BILL ......... Problem : 5 and more people use this File, So my was Change every time , i tried ... We Need lock Columns lock trick .. pleased solve my Query.
  3. K

    Change Font Color Black to White After Found " 0" Value In E Column , And may be I hope Hide row According Zero value. ???

    i was try "Change Font Color Black to White After Found " 0" Value In E Column , And may be I hope Hide row According Zero value. ???" how to possible Conditional Formatting ????
  4. E

    Issue with opening multiple files via a file name list via VBA

    Hi guys! Hope you are all well! This is the first time I try this forum, so please do let me know if I didn't do something correctly. Also, I am a self taught VBA noob, so it would be greatly appreciated if you can please dumb it down as much as possible in the explanation/code. Thanks heaps...
  5. C

    Need to copy from sourcesheet to destination sheet only the new data entered based on serial no on the source sheet

    I am totally new to Excel VBA. But I have a requirement to copy some data from let us say sheet1 to sheet2. I have several columns and rows in sheet1 (source sheet). Now I have to copy only Five columns data from within that where "Ferro Manganese" found in particular one coloum and if found...
  6. L

    VBA loop through multiple sheets, if value greater =>12 then copy row to combined sheet

    hey Guys I am having issues with my code. Originally (see original code) I would loop through all sheets and combine data in to one. This worked great. Only 1 sheet had headers (data spill). 'Original code For i = 2 To Sheets.Count Set xRg = Sheets(1).UsedRange If i > 2 Then...
  7. E

    Automatically Move row from 1 worksheet to another when a cell value changes in first worksheet

    :)Hi All. This is my first post I am hoping a kind person can help me ... I have 2 worksheets in a workbook. Worksheet 1 "Prospects' - lists client records for potential clients. Worksheet 2 "Income" - an Excel table lists client records for actual clients. In the Prospects worksheet, I...
  8. C

    Excel Debug

    Having an issue trying to debug someone's work, don't know this style of coding well and so not sure what is wrong here exactly but the error it says is user-defined type not defined, and I tried fixing this by defining it as a different declaration and that didn't work. ' Connect to the...

This Week's Hot Topics

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
Top