$$Excel-Macros$$ purchase sales in excel

HI All genius, In one sheet I have put purchases and in second sheet there is sales against purchase. In both sheets *RG* is unique id. In need sales data against Purchases. How to execute this function.? Please guide me in this -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you

$$Excel-Macros$$ Recover excel file opening passowrd

Dear Expert I have forget the passowrd of my old excel file .is there anyway to recover the password. ? Please help it is urgent -- 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

Re: $$Excel-Macros$$ month wise seq in pivot

how to create custom list On Friday, 2 August 2013 11:03:32 UTC+5:30, vijay wrote: > > Respected Hemal, > > Create a custom List and sort moths according to that custom list. > > > Regards, > Vijaykumar > > > On Fri, Aug 2, 2013 at 10:33 AM, hemal shah >

Re: $$Excel-Macros$$ want open first sheet while open sheet

; *Suman Kumar* > > > On Thu, Aug 1, 2013 at 3:53 PM, hemal shah > > wrote: > >> Hi,, >> >> It is not working, >> >> >> >> >> On Thursday, 1 August 2013 15:05:55 UTC+5:30, Priti_Verma wrote: >> >>> you can use workbook

Re: $$Excel-Macros$$ want open first sheet while open sheet

Hi Priti, it is not working On Thu, Aug 1, 2013 at 3:05 PM, priti verma wrote: > you can use workbook open event to active worksheet > Private Sub Workbook_Open() > Worksheets("Menu").Activate > End Sub > > > > On Thu, Aug 1, 2013 at 2:23 AM, hemal shah wr

$$Excel-Macros$$ want open first sheet while open sheet

I have 3 sheets in my excel book. First sheet is Menu sheet. I want that, Menu sheet is to be open every time when I open excel file. -- 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.fac

$$Excel-Macros$$ time wages calculation

Hi all expert see my attached file. I want to make excel sheet for time wages calculation. ..i want stored a time,when a check box is clicked in front respective date. as it is clicked,it should be locked. i used now function but it is updated continous basis... plz help -- Are you =EXP(E:RT

$$Excel-Macros$$ Re: Hi everyone,

HI following link will solve your issue http://ubitmenu.en.softonic.com/ Take care self and other Regards Hemal -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Pr

Re: $$Excel-Macros$$ sheet reference from cell

Thanks for your kind support and solutions. flower to you all,, made by me -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles.

$$Excel-Macros$$ Re: sheet reference from cell

# ref error... -- FORUM RULES (986+ 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

$$Excel-Macros$$ Re: sheet reference from cell

KINDLY USE MY ATTACHED FILE AND HELP ME OUT THIS... THANKS -- FORUM RULES (986+ 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 attentio

$$Excel-Macros$$ Re: sheet reference from cell

#N/A ERROR... -- FORUM RULES (986+ 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

Re: $$Excel-Macros$$ sheet reference from cell

=VLOOKUP(MAX('*EN8 BRIGHT DIA 28* '!$D$2:$D$11),Indirect(A2,"!$D$1:$G$11"),4,0) I dont want to EN8 Bright DIA 28. I just want to use cell reference instead . Thanks for your reply -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread

Re: $$Excel-Macros$$ return value with two look ups

thanks it is working.. -- FORUM RULES (986+ 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) Do

Re: $$Excel-Macros$$ return value with two look ups

Hi Sam Thanks for the solution but I want something different. Please see my attached file, which give you more idea regarding my query -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need H

$$Excel-Macros$$ return value with two look ups

hi all masters I have work on fifo in very simple way in excel. now in summary sheet i require , while i type GRN, i should get latest balance . I have attached file for your reference. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor

$$Excel-Macros$$ Cell editing VBA

Question : In attached excel sheet, there are columns named "GRN" and "Recd Qty"". I want VBA code for Reced Qty column's cell .. as soon as GRN cell is filled Recd Qty's cell is activatied, else no.. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread

$$Excel-Macros$$ Re: find doubling

If you have excel 2007 then follow the following procedure Select the your data range and go to Home --> Conditional Formatting -->Highlight Rules--> Duplicate Values.. It will highlight your duplicate data and by filtering it you can copy it. Regards Hemal 9260544391 --

$$Excel-Macros$$ Re: Numbers errors

Better to add single quote ( ' ) before bank account number . and while you copy that number to another cell, it will remain same. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks

Re: $$Excel-Macros$$ Make database with user form i have made

e = .txtAnn > >> End With > >> Application.ScreenUpdating = True > >> Application.EnableEvents = True > > >> End Sub > > >> -- > >> Thanks & regards, > >> Noorain Ansari > >>  *http://excelmacroworld.blogs

$$Excel-Macros$$ Connect user form with excel cell

I have made user form for basic salary. i just want to connect to excel cell... In short , i want to make database through that form. .. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tr