$$Excel-Macros$$ Compare two sheets with same columns

, Vickey -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need

$$Excel-Macros$$ Get particular text within text from one cell

g formula in excel. Thanks & Regards, Vickey -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread ti

Re: $$Excel-Macros$$ Comine Text

're a blessing or a lesson...* > > On Sat, Apr 2, 2016 at 11:20 PM, vickey > > wrote: > >> >> >> Hi, >> >> Please help me out to solve this problem, I have following table. Now >> what I want to have result as third column "Combine". &

$$Excel-Macros$$ Comine Text

Hi, Please help me out to solve this problem, I have following table. Now what I want to have result as third column "Combine". Srn Name Combine 1 A A, B, C B C 2 D D, E E 3 F F, G, H, I, J G H I J 4 K K 5 O O, P P -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you

Re: $$Excel-Macros$$ Change return value of data from one sheet to other by entering value in cell

hi is there any update...? -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't p

Re: $$Excel-Macros$$ Change return value of data from one sheet to other by entering value in cell

Hi, is there any update in my case. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2

Re: $$Excel-Macros$$ Change return value of data from one sheet to other by entering value in cell

Ofcorse it can hve macros, the idea behind it to store invoice data. If macros is being used then to make it more good other then active sheet can be hiden. Vickey -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like

Re: $$Excel-Macros$$ Change return value of data from one sheet to other by entering value in cell

thank a lot -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a que

Re: $$Excel-Macros$$ Change return value of data from one sheet to other by entering value in cell

Hi, Please find attached sample file. regards, vickey -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention

$$Excel-Macros$$ Change return value of data from one sheet to other by entering value in cell

01/10/2011 then values from October sheet should return in designated cell thru fourmula. So could you please help me out to solve it. Thanks in adavnce Regards, vickey -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread

Re: $$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria

Thanks, It worked, but there is one argument, if there are more then three entries in a particular day i.e. on 1st of sept there are three diffrent times mentioned or more than that, then very first and very last time should reflects. (means in time of morning and out time of evening) I have

Re: $$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria

Yes, great its working can I raise more query/issues in case I face during the operation... -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twit

Re: $$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria

Thanks a lot I got the idea but however I am trying somthing diffrent as per attached forward, I have used your suggested code in the field, but there is problem of updation of values if I enter employee code highlited in yellow as per sample file attached. Pleaes have a sample copy of the ide

$$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria

can I get values (time) of two same values in accedning order with two Criteria. for example I have employee code / date & time now employee code repeates two or more times in a day with diffrent times. now what I want if I select parcticular date with particular empoyee ID then time of that

Re: $$Excel-Macros$$ Can Excel be used as msging

well assuming I am having a shared excel acorss network, now what I want If I update any value in designted cell, the value of that cell must be prompted and updated in other designated cell which can be viewed by other user and visa versa, just like chat. Vikas -- --

$$Excel-Macros$$ Can Excel be used as msging

Hi, can anybody let know is there any way to use shared excel to share message realtime in form of msgbox thru VBA code. Vikas -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks

$$Excel-Macros$$ VB Code Require for Data Compilation

Hi, I am using a huge database of family and members, with column address / DOB / Emp Code. Now what I want, since the address and EmpCode is only agaisnt primary member, so after executing command, I want that address should be filled in each member of family alon

Re: $$Excel-Macros$$ Re: copy cell value from clicked hyperlink

Thank a lot sir,, its working... vickey -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http

$$Excel-Macros$$ Re: copy cell value from clicked hyperlink

to reduce/minimize the time for typing no mannually. hope I am clear on this. vickey -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com

$$Excel-Macros$$ copy cell value from clicked hyperlink

Is there any way to to get cell value from clicked cell hyperlink. i.e. if there is sr.no. 1 in cell A1 in sheet1 and it is hyper linked with sheet2 the value of sheet1 A1 (1) should reflect in Sheet2 A1 or anywhere. Please help me out to get it solved. thanks in advance.. vickey

Re: $$Excel-Macros$$ filter of nonblank cell

"Data").Range("A65536").End(xlUp).Row + 1) >         Next > End Sub > > > > -Original Message- > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > > On Behalf Of vickey > Sent: Monday, July 25, 2011 7:42 PM > To: MS

$$Excel-Macros$$ filter of nonblank cell

Is thereany way to filter / copy nonblank values toanother sheet. considering followng example. ID NAME 1 2 BBB 3 CCC 4 5 6 7 DDD 8 FFF 9 EE ID NAME 1 2 BBB 3 CCC 7 DDD 8 FFF 9 EE thanks in advance

Re: $$Excel-Macros$$ Max value from a set of group

Thank you so much sir, but I have one query, the maximum salary must reflect against relative salary, becuase there is further formula for other members to increase rest of the members their salary by 20% of maximum. could you please help me out further please find attched sample excel. Thanks

$$Excel-Macros$$ Max value from a set of group

How can I get maximum value from a set of goup i.e there are two to three families out of this from each family maximum age of family member is require in next colum corresponding to maximum age member. for example A xyz 45 A uyy 33 A yss 65 B sas 34 B ree 45 B ww 55 taking to abobe exam