yyy

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 am sure that this is easy, but I just cant get it. I have a data set that I need to create different arrays based on values in the data set. Value 1 is our starting point of our array. Value 1 is a variable that I have created a helper column in Column H which will have "Start" in the cell...

Hello, I need some macro who can make from this table : <colgroup><col style="width:48pt" width="64" span="2"> <col style="mso-width-source:userset;mso-width-alt:7606;width:156pt" width="208"> <col style="width:48pt" width="64" span="7"> </colgroup><tbody> 9 X xxx 1...

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...

Hi, I'd like to have a vba code for that problem. If column "R" contains whether "xxx" or "yyy" or "zzz" then delete from the specific rows thw following cells: U:AD and AV:BE and BW:CF and CX:DG. So, for example in column "R" it finds "xxx" in row number 15 and "yyy" in row number 22, than...

Hi Everyone, I am facing trouble with data for which I get list of files with specific fields. I need to scrutinize and form it in table format. Eg Input Name: XXX Age: YYY .. Name: WWW Age: TTT ... Output NAME Age XXX YYY WWW TTT......

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...