covered

  1. N

    Improve Cut Paste to Another Sheet Based on Multiple values in cell

    Can anyone help me? This code works but it takes toooo long to run. Is there a way I can rework the de to speed it up?Thank you,Nate Sub MoveLS() Dim i As Variant Dim endrow As Integer Dim ASR As Worksheet, LS As Worksheet Set ASR = ActiveWorkbook.Sheets("Detailed Activity") Set...
  2. L

    Checking cell based on value of another cell on another tab

    Hello guys, I'm having the following issue: On the tab "Auditierte Normelemente" I would like to have an overview of which elements of an audition are being covered. So, if the topic 4. Kontext der Organisation (B7) got covered in the year 18-19 (Column C), I would like an X to appear...
  3. L

    custom filter

    Hi I have a column which has random dates. I inserted a filter. I click on Date Filter and I see all options, after, before, between etc. Then I see custom Filter and I see AND and OR. I just want to know an example that I need to use these 2 options. I thought everything is already covered...
  4. L

    Vlookups + SUM

    Hi, Is there a way to use VLOOKUPS to find a selection of the same reference and add them together to give you a result? For example. I've got this list of Holidays that need to be covered. In Colomn L I have Vlookups that are taking data from another table. In this table the first colomn...
  5. L

    Conditional formatting Question

    Hi guys, Got a problem. I've not used conditional formatting much before and unsure how to get it to work properly for my particular situation. I've got these cells I want the conditional formatting to give me a data bar for whatever number is in the days covered column compared to the...
  6. A

    Array calculations instead of SUMPRODUCT

    Hello, I have a workbook I'm using as a tracker of how many tasks were done in each day of the year. Each week has its own worksheet (and is named by the week's number - e.g. "35" if the dates covered are between the 21st and 27th of August). (Tracker sheet) <tbody> A B C 1 Tasks/Date...

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