south

I have a VLOOKUP formula that works on the first cell it is used. However, it fails on all subsequent rows. This is my formula...in cell V2 where it works. Then when copied to V3 it fails. =VLOOKUP(W2,'Engineering'!$C$2:$J$375,8,FALSE) This is the formula I have in V3... =VLOOKUP(W3,'OSP...

Hi I have a macro below which find and replaces countries with reference numbers which is working ok however I need to exclude column H, I have tried adding the range line below but it is not working and I keep getting error message, I would be grateful if any advice. Sub Multi_FindReplace()...

I have the following macro which I have edited and would be grateful if some could please help me edit it so it only looks sheet1, also have I done this correctly so that it will find and replace? Sub Multi_FindReplace() Dim sht As Worksheet Dim fndList As Variant Dim rplcList As Variant...

Hi, I have a two sheets and I need to copy data from sheet one and paste it in sheet 2, the issue is that each contact on sheet 1 has a field called country of birth which is fine however to use that information and paste it next to their record on sheet 2 but with a reference number instead...

Hi Here I am looking to highlight (the entire row) the lowest sales by region in VBA. Thanks <tbody> ID Region Sales 100 East 1000 102 East 1100 103 East 1200 104 West 1000 105 West 1100 106 West 1200 107 North 1000 108 North 1100 109 North 1200 110 South 1000 111...

Good day, I require assistance please. I have to calculate an average based on the monthly contract data. We have a Hit rate per customer per month and some of our customer have contracts with us, but the contracts were not implemented the beginning of the year. Some were only implemented...

Help would be great people. Could someone point me in the right direction with a formula that would calculate the aggregated Total (Col B) for South Location (Col C)? The answer should be 14. And if it's not too much, the Total for South Location where the Severity is High? Should b 9. Thanks...

Hi, I posted earlier, but i have managed to get somewhere. I am using the below code to save a master spreadsheet (holiday planner) in another location however, it is only saving the one sheet i have specified but i want it to save all of the sheets. i don't know how to amend the code to save...