-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
polk
-
T
If the formula in a cell is blank then do nothing else run code
Hi Guys, I'm struggling how to add some additional code to the below. Essentially, if the formula in Allocate!e16 is equal to blank, then do nothing, else run the below: The formula is Allocate!e16 is =IF(E16<>0, D16, "") Sub Payam_Naeini_New_Calls_Service_and_MOT()'Payam Naeini...- thedeadzeds
- Thread
- filter formula mot polk service
- Replies: 1
- Forum: Excel Questions
-
T
Join Several VBA Codes together
Hi Guys, Just wondering if there is a way to turn the below 3 codes into one. I have 15 of these in total (3 is just for example purposes). The code essentially filters based on 3 columns, selects the number of rows based on a cell in the 'Allocate' tab and then copies to the 'All Data' Tab...- thedeadzeds
- Thread
- filter mot polk react service
- Replies: 1
- Forum: Excel Questions
-
T
Change VBA to paste as values
Guys, how do i change the below to paste as values only? Sub Bethan_New_Calls_Service_and_MOT() Dim sh1 As Worksheet, sh2 As Worksheet Dim i As Long, j As Long Set sh1 = Sheets("Audi Service & MOT New Calls") Set sh2 = Sheets("All Data") 'Filter New Call Sheets("Audi...- thedeadzeds
- Thread
- change filter polk sh1.cellsj values
- Replies: 6
- Forum: Excel Questions
