Search results

Hi Ninjas please help me for macro to vlookup on column header instead of column ref number on all open workbooks.

Hi Ninja i am doing daily more than 30 vlookup on below sample "Global LDD" file and other many files too. to my below "APAC " file, my problem on my macro is, i am using column ref number to vlookup, however on my sheets new columns will add in mid on every monthly basis so lookup reference...

Hi Ninja Team i am using below code to vlookup on other open excel file, now i facing issue is, every month one new column is adding mid on open file, so lookup reference column number is pointing to next column, !!! please help me to vlookup on column header instead of ref number Sub...

Thanks u All Ninja's Thanks again for all your time and help !!! it saves me much time.. :)

HI Team As suggest, i have attached the complete sample data sheet,data range is not fixed my original file Please suggest any way on VBA to achieve this rather than Power query Kindly help me - Thanks in advance

Thanks Ninja I am using Office 2013, the above formula not helping for me, as i mentioned earlier, i have dynamic row sheet, more that 550 to 700 rows daily in both sheets ,, i cant fix the range only Q2 to Q5 in formula, please help !!

Hi Ninja Team If we Vlookup the value. it will display only the first match data. However i need to display all matched data for my lookup. i have below dynamic raw file with 1000 rows , if i vlookup sheet1 B with Sheet2 B:Q i will get first value only " =VLOOKUP(B2,ALE!B:Q,16,0) it is...

Hi ninja team Please help on my above requirements, how to achieve it, Or pls suggest any clarification needed on my query which I not mentioned

Hi Team : Please find the detailed explaination and to help me for my quest Every week Ageing (B column) will increase Every week caseid report will show movement from pillar to pillar or will be in same pillar , based on movement, I will update the comment as Not stated , WIP and completed...

Hi team Kindly help on my query, a bit of advise request

Hi Ninja Team as per below image, I have caseid will move from pillar to pillar as 1.client comms 2.Account Linkage, 3.FFC 4.CRD every week caseid will move to other pillar or will be in same pillar , based on movement, I will update as comment as not stated , wip and completed I have...

sorry for confusion , i try to clear.. please Column A for one CaseID have multiple ClientID in column B i do vlookup to D column with other file - if all ClientID is NA for same Caseid , then only i can Offboard, otherwise i cant tricky 2 combination occurs ************** conditions...

Hi Marc, , i done by formula =IF(COUNTIF(B:B,B121)>1,"Duplicate","Unique") My caseID is repeats , here i taken only duplicate cases please find the below 3 different conditions bases on D & E Column combination 1. If D column = NA and E column = Duplicate , So comment as Good to off 2. If D...

Hi Ninja Below is my sample data, Column A in one CaseID have multiple ClientID in column B, below are my requirement is, 1. when caseid is not repeated ( have single Client id ) -> My comment be - Good to Off 2. when caseid is repeated ( have multiple Client id) -> my...

Hi Ninja i want to copy data from pivot table to my MIS sheet bases on filter condition. below is a piece of code i prepared , Here by i attached my file . I want to select ColumnRange + DataBodyRange without last row and last column and paste in MIS sheet please help and thank in advance...

Thanks vletm the for your time .. this is what I wanted,, Thanks again

Hi Hany Herewith I attached the file with sample data, but my real file as more has1lakh rows below i am using concatenate small code to add ; at end of each record >>> use code - tags <<< Sub batch() Sheets("main").Activate LROW = Range("A" & Rows.Count).End(xlUp).Row...

Hi ninja My excel column as more than 1lakh rows, 1.I want to covert in to (add ; at end of value ) to generate reports in our application A- column ----------------- 1097456607 2087765673 4678296689 Convert to :: 1097456607;2087765673;4678296689...... i can't concotinate more than 36k...

Hi Ninjas Below and attached sheet is my sample database, where i need to add "Days" at end of numbers in each cell in all columns. i have code that works for A columns , i want the code that work at all column range .. i tried range of ("A:H") But it not woking please help and Thanks in...

Yes sir,I mean that I will ensure all possible Condition and requirement post in thread at first ---I didn't understand mean 11 different renewal -- I do no what to answer for every day value -- if fixed Columns for all 15 lobs for renewal and non renewal -- 30 coluns will fixed --- please...

Hi sir You should focus. --> i assure, i will be more focus in furthers i wont repeat it again 1) 'find Word "Rejected" in 16 Red highlight columns' almost same '15 red color Highlighted column names' -> only 15 red columns names 2) Do You mean 'just remember' something very important? --->...

Hi Sir Kindly apologize for my repeated mistakes, 1.Question : 'LOB Names- 15 red color Highlighted column names are LOB(Line of Business)names Ageing Bucket - AR ,AS column in sheet are Ageing bucket 2.Question : sorry sir,i forget to add very important 2 point missed in my fist post...

Hi Sir sorry, i did't understand your first question - please excuse please help to segregates ageing bucket based on "G" Columns Renewal and Non Renewal

hello sir, Thanks for your help!!! sorry sir, some condition missing in code that- count of each Lob Rejects should segregates based on "G" Columns Renewal and Non Renewal as per my manual result sheet Kindly help sir, this condition is very important Line of Business Mkts - E trading...

Hello sir, Thanks for your help!!! sorry sir, some condition missing in code that- count of each Lob Rejects should segregates based on "G" Columns Renewal and Non Renewal as per my manual result sheet Line of Business Mkts - E trading Mkts-Collateral Non Renewal Renewal Non...