Search results

I would like to be able to check my data and if the word "Type" Column A and "*Essentials*" Column J (would need to use a wildcard) not on the same rows is found then add a row and add the words Play > Essentials. I only need this to happen once for a Heading, and then to look further down my...

I have multiple worksheets in a workbook named Supplier Master Price List.xlsm. I have a Workbook named Source and in Col G I have a formula vlookup to look at all the sheets in Supplier Master Price List workbook and if a Part No: is found place the value.

Can anybody help with this?

I need to change the formula below to look at all worksheets in another workbook the formula I'm using works but I need to change Free Standing to MySheets. The formula has been shortened it usually looks at 10 other worksheets all with different names but all in same workbook (supplier master...

The thread that you sent me to consolidate into one worksheet I have asked for it to be copy into matching worksheets of another workbook

Need a vba macro to open a Workbook (folder directory will also be the same but not the name of the workbook), copy multiple columns A:K in each worksheet and copy it to the activeworkbook. I cant have the vba in the workbook that I need to copy from as this comes from someone else. My...

Can anyone help with this?

Module 11 is the code I wish to modify. You will also see the example I have put in the file is I would love to change the Site and Location into 2 columns.

I have put an example on the JobOrder worksheet under column K2

I am using this code and its working great but I need to know if I can join 2 columns together. I need column A and E columns to join together then a comma in between the next A and E something that looks like this FS15 - Backhoe, FS105 - Badminton Net Free Standing, FS22 - Ball Toss Sub...

Can anybody help with this. TIA

Sample has been attached

Sample Blank Work Cost.xlsm attached

I have 2 worksheets "Cost" (name never changes) and "Option1" (names changes regularly) I am using this code that works really well but I need it to change to a define name range "d1:D5000" Named range = "Part_No" I need it to loop through my "Cost" sheet Column "B30:B78" and place the...

Thanks for the code, where do I place this into my vba

Can you skip rows that are hidden in a worksheet. I need WS Option1 to find all words Safeplay and copy contents to WS Safeplay. Sub MoveOption_to_Safeplay() Dim SheetName As String SheetName = "Option1" Dim i As Long Dim MyCol As Integer Dim MyRow As Integer Application.ScreenUpdating =...

I also found something on your original macro it only shows the first of any of the criteria but runs down the length of my sheet to end and highlights only 1 of each. I have multiple times Dial or Special or Underground is in Column A. I also have blank lines in column A so I dont know if...

Thank you very much for your help

Hi Smallman Just wondering if you had a chance to look at this, Thanks

In my code it looks for the Word Dial (for instance) in Column A and then Column F if the word Booked and then Column J if date all 3 of these have to be filled in for the colouring to be attached. In the other matter I need it look for the same in Column A and then if look at Column J and P...

Firstly the code that you wrote is great but I need it to colour if all these criteria's are met not just Column A. The code that I attached works great but I need now to move further along and start putting in schedule dates likes a gantt chart. The below was a conditional format and I have...

Can anybody help with this?

Ok I am starting to get somewhere but need a bit more help This is the code I am using in another part of my worksheet and it works great. I just need to be able to add modify or create new for next part of worksheet Sub CondFormatMultiColour() Application.ScreenUpdating = False Dim...

I have tried to macro record with no luck and tried to add my conditional formatting with no luck All the conditional formatting help I see on all the sites don't seem to help with what I want I looked at the site above and tried to do it myself I started with this...

That works terrific but I have at least 30 conditional formats and I believe it makes my workbook very large. Is there no way to put the conditional formatting into a macro that runs after the above code.