Posts by aroy1195

Hello Rama,

Thank you once again.
I sorted that out. What I wanted to do was to first filter out data from sheet 1 and then delete data from the filtered out result using the mappings.

Thnak You fro your response guys. I am trying out @B Rama Krishna's code first..just needed a little tweak..i want to a filter first for column A in sheet 1..say the values are Data,Data 1, Data2 and I want to filter out ranges having data and data 2 as cell value and then perform the mentioned code above on that filtered out data...can you help [USER="334446"]B Rama Krishna[/USER] ?

Here's a dummy file. Here Data on sheet 1 has to be filtered out using data on sheet 2. That is find all the rows that have the data present in sheet 2 and delete the rest

Hello,

I want to create a macro which can search and match values in a particular column and filter out data based on it . The values that need to be searched would be present in another sheet.The rest data that does not match the criteria are to be deleted(entire rows)

Thank you for your help [USER="328923"]Tom Rowe[/USER]. It worked.

I want to write a macro which would check if a data sheet has a set of columns and if not then add a column with that header.

Say, I want columns Col1, Col2, Col3, Col4, Col5, Col6, Col7, Col8, col9 to be present and in the same order but the data sheet has missing columns in between so I want the missing column to be created there with the header.

Thank you for your help [USER="33159"]KjBox[/USER] that worked

Sorry, didn't notice it was a pdf... Here's the xlsx

Can't upload the actual so have prepared a dummy sheet of the same. So what I want to do is check the values in column F and accordingly put values in column G, H, I.

Say, for F column cell value=x the corresponding parallel cell in G will have XXX, in H will have YYY and I will have ZZZ

Getting an error saying Invalid or unqualified reference on the 3rd line

I want to write a macro which would check the value of cells in column f and fill column g, h and I cells if condition is met and this is for the entire column range.

The column f in total has 3 different values.

Say if- cell in column f has value x then I want column G cell to have AAA, column h cell to have BBB and column I to have CCC.

Similarly if Column F cell has value y then G, H and I to have AA, BB, CC respectively.

Can any one help me out please.