zzz

How to write a VBA code to get the below output. Thanks If Column A = AAA , Column C = XXX , Column E = YYY Then column F = Yes If Column A = BBB , Column C = XXX , Column E = YYY Then column F = Yes If Column A = ZZZ , Column C = XXX , Column E = YYY Then column F = Yes and if Column A is...

Hi there I am hoping for your help in creating a macro that will automate a repetitive piece of work I am doing I have a sheet with data in column A and B, both having headers. Column A contains a name and be B has a reference to an account. Some have references to multiple accounts and are...

I saw a great video yesterday that allows me to make a list within PQ from ExcellsFun YouTube that can make a list from A to Z. I then Tried to make a List going from either AA to ZZ or AAA to ZZZ. I created a Blank Query that simply had ={"AAA".."BBB"} however it didn't like that. Is there a...

Hello Guys, I have two scenarios to workout. Both are almost similar only small differences. I am using simple find and replace for this, but now i am having new issues. Please go through the following scenarios. Scenario 1 The macro should read the cell C3 and delete that value in the last...

Hello, I want to replace only whole words in a cell Also, I do not want to use Replacement, I want something I can use with Arrays The function does a good job of finding only the whole words but is there a way to get it replace the whole word with the MatchExprValue Ex cell value =HUD...

Hi All I'm an OK user of Access (not VBA) and seeking some assistance. I have a query that is working out the distance between postcodes in the UK. I have for example, 16 unique postcodes in one column of data, and another 16 unique postcodes in another column. I was expecting to get 16...

In the following code I have 'FitToPagesWide' and tall = 1, but when run, it still shows up on two pages. What am I missing here? Much thanks for any help. Sheets("Original").Select Do Until ActiveSheet.Name = "zzz" ActiveSheet.Next.Select RowNum =...

I have an excel sheet where equally spaced columns starting from AD (AD, AI, AN, AS, AX, ...) contain a string. The string can be anything from a set of 4 pre-defined strings. Requirement - Find the string that occurs most frequently in these columns. Example AD -------- AI ---------- AN...

Hi, I'm looking for a way of identifying all entries for a Patient ID where the Patient ID's have conflicting "Country of Birth" entries recorded. Entries for each Patient ID may all say either ZZZ or GBR, but they cannot say both. The problem with identifying them being that: Rows may...