dict

  1. most

    Macro to consolidate some data

    I'm stuck, i'm working on a macro which should consolidate some data. See this printscreen. The macro should produce one line for each date with an average, min and max of temperature and humidity. This is as far as I have come, I manage to print a dictionary with the data, but I don't know...
  2. B

    Copy If Not Exists

    Good Afternoon all Looking to copy values [to another worksheet] from Column H which are not in Column T This Script highlights column H values not in Column T - hoping for some insight how to attain the above request. Thanks guys. Sub CompareRangesII() Dim r As Range Dim Dict...
  3. E

    Add offset to my macro

    Hello Guys! I need little help with my script. It compares A2:A from two Sheets and if match it is copying cell F of one shhet to cell K of the other. It works fine But... I want to compare not only A2:A but A2:A and Offset(,3) to Offset(,4) something like Kl.Value & Kl.Offset(,3) to...
  4. E

    Refactor my code

    Hello Guys! Can You help me refactor this code to be more noobie frendly? Or it is good as it is? (code is not mine and I bearly understand it) It looks for the same values in two sheets and if match it copy value from other column of found row to yet another column of searching row...

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