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...
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...
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:
Dim x As Integer
Dim wkbAll As Workbook
Dim wkbTemp As Workbook
Dim sDelimiter As String
Application.ScreenUpdating = False
sDelimiter = "|"
FilesToOpen = Application.GetOpenFilename _
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...
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...
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...
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.
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...
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:
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...
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...