I currently have a large worksheet that is similar to this:
With the master data looking like this:
I want to create a sort of IFERROR(IF(INDEX=0, ,MATCH and MATCH formula (with an iferror that returns "" (blank) if there's an error)) for every column with  such as [DATE].
Dim oPL As Double, o709 As Double, o710 As Double, o713 As Double
Application.ScreenUpdating = False
Sheets("Calculation_Sheet").Visible = True
Note: P666, P709, P710 and P713 are global variables...
Private Sub UserForm_Initialize()
lb_hello.Caption = msg
lb_tec.Caption = Tec
Dim mHour As Integer
Dim msg As String
mHour = hour(Now)
If mHour < 12 Then
msg = "Good Morning"
ElseIf mHour < 18 Then
msg = "Good Afternoon"
I have a macro that I have assigned to a button which looks at a certain range of cells formatting, and upon clicking on the button, it copies the cell formatting of the range, and copies it to another range on the same page and also other cell selections on another sheet.
I also have some VBA...
I am trying to make a code that makes the program write data in a specific excel spreadsheet according to the value of the variable "MachineName" declared as public
What happens is that the program does not allow me to do it because an error is detected on line 96
I currently have something similar to this:
Linking to this:
It should return the date 21-06-2019 for XG10, but it does not.
Can anybody see what I did wrong and how to fix it?
Would be greatly appreciated! :)
I currently have a large list of data, but to simplify, here's a simple example:
I currently wrote cell C5 as = J5
I then pulled it through the green box as you see in the photo to the right and got A, B, C, D and E and pulled it down and got 1, 2, 3, 4, 5
However, I want it to...
I am updating a document for work and which shows projects being worked on and their status.
I would like rows which have been marked as "Archive" to be automatically moved onto another worksheet so as not to clog up the current work. How do I input a code to enable that to work...
I have a table with 45 members and let's say 100 columns. Each column is a date and members will have a negative figure within the cell referencing their name and the date if they have a holiday. (EG John Smith is off on 12th June so he would be -8 in cell H22).
I want to be able to...
I currently have this formula:
Right now the cell is showing a blank cell.
I then have another cell that links to this cell through this formula:
This cell also shows blank, because the first cell is blank.
I then have a third and final cell with this formula:
So i have 4 different tables with a set amount of columns each (2 with 2 columns and 2 with 3 columns. all are named differently). The thing is that if i get a new item i need to enter its itemnumber in those 4 tables in the respective row.
Is there a way with a macro to fill the cells of my...
I have a very simple VBA code, that I use to create a new folder. MkDir "C:\Users\aan\Desktop\" & [A1]
I keep trying and failing to make both parts of this a cell reference. I need both the location and new file name to be changeable.
Whenever I open a PowerPoint document, the function "Embed fonts in the file" is turned off:
Is there any way in which I can make it so this is automatically turned on?
Thank you! :)
Why the below code is not copying data to till last row
LR = Cells(Rows.Count, 1).End(xlUp)(2).Row
Range("N2").FormulaR1C1 = "Max"
Range("N3").FormulaR1C1 = "Min"
Range("O2").FormulaR1C1 = "=MAX(RC[-9]:RC[-9])"
Hey friends. Im New in VBA. Could you help me at this?
So, we have 2 columns: AB with data, in Sheet1
I want to COPY until Last Row in AB Column from Sheet1
and paste it to Sheet2, column CD in FIRST EMPTY ROW (i mean while adding more data, cause CD is supposed to have previous data)
I'm very new to Macros and all things excel and have been trying to find the correct code or help for days.
I have a few urls that are all dynamically built with the hyperlink formula based on populated data on other sheets. One of my sheets contains all the of website formulas for the...
I would like to move rows from one sheet to another, depending on the content in Column Z. The value for go-ahead is "0" (as this means there are 0 blank cells in the row).
I have managed to move my completed rows from "Complete" to the next available row in "Archive". This pasting into...
We have Two Workbook in same location
now we want to copy data from Test, Sheet1!A2:A and paste in Data, Sheet1!A2:A
and we want to copy data of Test, Sheet1!B2:B and paste in Data, Sheet1!C2:C
we have a large data where we want to get some result, we have formula but want to convert it to in vba
Our Steps are
1. First time we are checking the value in T column if we have got the value then second step
2. We have got the value in T8, now we have put the formula...