# multiple actions

1. ### Count Unique Data Sets Over Multiple Columns

Hi, I am struggling to create a formula that returns a singular count for data sets over 2 columns (that are multiple columns away from each other). I want the formula to count something only if: It is only counting any number in Column A once. It is also only counting the unique number in...
2. ### Lookup for attendance to return who is eligible for bonus.

Hi all, I am looking to create a formula that will look up a list of employees and check to see if they have had any sickness incidents within a month. This will then show eligible or ineligible for their name. I have tried various IF and VLOOKUP methods, and that is where my knowledge ends...
3. ### Combining Data from 3 Cells into 1

Hey guys, bit of a tricky one here and would love some help, will try explain as well as i can. In the cells below i have A1-C3, A1 tells me if the action has been completed, No means it hasn't and so no. B1 tells me the device used C3 tells me the product The formula i am after will...
4. ### Combining Data

Hey guys, Struggling here with a big project of mine and really need some help! So the data i get in has two columns, a and b. In a it provides me with two answers either yes or no. This tells me if this was planted or not. Column b provides me with my trees data tag. i need to find a way to...
5. ### Count of date values which are in different columns but are of same week in pivot table

Hi All, I have a data table where we have Roles (varies) that people have been contacted for. Columns B:G contains the dates of the activity performed (e.g. when were they sourced, when they shared their interest so on and so forth). I need a dynamic weekly report which gives us count of all...
6. ### VBA Copy multiple ranges, paste in a separate sheet and arrange neatly

I'm trying to copy a couple of ranges from multiple sheets and paste them in a separate sheet in a well arranged manner. So I should create a new sheet (we can name it PDF Template). Paste the relevant Ranges(Tables) and format/distribute them exactly as it is shown in this one: with...
7. ### Macro for summary making

Sub Import_Text_Files() Dim FilesToOpen Dim x As Integer Dim wkbAll As Workbook Dim wkbTemp As Workbook Dim sDelimiter As String Application.ScreenUpdating = False sDelimiter = "|" FilesToOpen = Application.GetOpenFilename _ (FileFilter:="Text Files...
8. ### VBA - Export Specific Column every 30 rows to .txt file

Hi VBA Wizards, I have been battling to get this working. The purpose of this is that our customers need to enter a particular format to order in our b2b system. We have a problem with our ERP handling the .xml so limit the customer's orders in the b2b system to 30 lines per order. We would...
9. ### First in First Out (Fifo) Stock balance Calaculation File.

Hello there, I actually need help in a simple task of stock balance calculation but due to this task being a daily task and my input files having least 200 entries to work on for this task I am having many difficulties. Kindly help to kind of Automate this task (or at least reducing manual...
10. ### Generate metrics for one vehicle when fleet, make or specific registration is selected

Hi, We've got a fleet of 58 vehicles that we used to manage by registration, so for example we would get individual requests per vehicle for MOTs, servicing, breakdowns, repairs etc. Every entry is tied to an individual vehicle, so there are hundreds of entries but it's fairly straightforward...
11. ### Syncing Excel Daily Task reports

Hi I am trying to see is there an easy way to create a process (I think), where all the Employes have the same form to fill daily and that this information to load into a master form without having to load one form individually.
12. ### VLookup only if Conditions meet

Hi All, I am trying to achieve a simple logic. Tried to search over google and forum before asking but couldn't get anyway near. I am currently using below formula which is working fine but need to manually delete extra rows to obtain conditions. (In Table) =IFERROR(VLOOKUP([@[Mobile...
13. ### Count the cells with specific Font color within the range of cell that have a specific background color

Hi all, I want to know how much cell have a blue Font color within the cells that have a green background (and so on, 5 background colors and 5 Font colors). Exemple: I have 20 cells that have a green background, from those cells how much have a blue Font? Here are my formulas: Background...
14. ### Multiple private subs in worksheet

Hi, This is my first post, hope get this right. I am newish to VBA and have come up against problem (first of many no doubt). I have searched for an answer on the forums and Google but not finding one that works for me. I need to put multiple private subs in one work sheet but am unable to run...
15. ### Multiple actions

Good Evening all, I have this code that a wonderful user gave me some time ago below. The code below allows me to enter a number in A1 and it will show a that number of rows between the first visible row (6) and the last (43). I am hoping there is a way to add multiple actions in this code...

### 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.

### Which adblocker are you using?

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

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