Re: $$Excel-Macros$$ Re: Enable/Disable text box based on User Login

2015-12-29 Thread Rajeev Kumar
Please find attached file and help as per requirement. Thanks in advance On Wed, Dec 30, 2015 at 9:40 AM, Mandeep Baluja wrote: > Check this attachment !! userid for admin is : admin and password is 123 > same as for Guest. > > Regards, > Mandeep baluja > https://www.facebook.com/groups/8252214

$$Excel-Macros$$ Re: Enable/Disable text box based on User Login

2015-12-29 Thread Mandeep Baluja
Check this attachment !! userid for admin is : admin and password is 123 same as for Guest. Regards, Mandeep baluja https://www.facebook.com/groups/825221420889809/ -- 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

Re: $$Excel-Macros$$ Enable/Disable text box based on User Login

2015-12-29 Thread Abhishek Jain
Please share sample of your worksheet and mention what textboxes you want to be disabled in Guest mode. Rgds, Abhishek On Wed, Dec 30, 2015 at 11:08 AM, Rajeev Kumar wrote: > Dear Experts, > I am here by requesting for an sampel workbook for following: - > 1) When open a workbook, it should po

$$Excel-Macros$$ Enable/Disable text box based on User Login

2015-12-29 Thread Rajeev Kumar
Dear Experts, I am here by requesting for an sampel workbook for following: - 1) When open a workbook, it should populate login user window. 2) Two type of user id should be there A) admin, B) Guest 3) When we log as admin, it will go on top sheet where i have made many text boxes linked with diffe

$$Excel-Macros$$ Re: Introduce Yourself !!

2015-12-29 Thread Anup Singh
Hello, I am Anup Singh, working as Finance Manager in event management company. I am keen to learn advance excel and VBA. Regards, Anup Singh On Saturday, June 9, 2012 at 12:51:59 AM UTC+5:30, Ayush Jain wrote: > > Hey all new and current posters, > > Welcome to excel group,one of the large

$$Excel-Macros$$ Re: purchase sales in excel

2015-12-29 Thread Mandeep Baluja
Hi Hemal, You need Sales Qty against a purchase through RG which can easily retrieved in attachment through sumproduct Note: Duplicates values in sales table is summed !! If you want to get all the details from sales table to purchase table,There you need to mention Which row you want to ret

$$Excel-Macros$$ Re: purchase sales in excel

2015-12-29 Thread Vicky Jorwal
Use Index and Match Functions It'll be easy... Regards, Vicky On Tuesday, December 29, 2015 at 6:46:37 PM UTC+5:30, hemal shah wrote: > > 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

$$Excel-Macros$$ purchase sales in excel

2015-12-29 Thread hemal shah
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$$ Re: macro for hard copy of formulas

2015-12-29 Thread Mandeep Baluja
Check this out is this you're looking for !! Regards, Mandeep baluja Sub GetDetails_of_Sheet() Dim ws As Worksheet Dim i As Long: i = 2 On Error Resume Next Application.ScreenUpdating = False Application.DisplayAlerts = False For Each sht In ActiveWorkbook.Sheets If sht.Name = "Info"

Re: $$Excel-Macros$$ plz help

2015-12-29 Thread Mandeep Baluja
Dear Sudhir/Pankaj, First thing you should not is this showing Error because of regional Setting, because both of you're using different Date format,As I check this file it shows me the same error because My System format is "dd/mm/" While the answer in sheet is in format mm/dd/,Wheneve

$$Excel-Macros$$ macro for hard copy of formulas

2015-12-29 Thread Izhar
1) SUPPOSE IF THERE ARE TWENTY COMPLEX FORMULAS MENTIONED IN A SHEET THEN HOW DO WE CODE A MACRO WHICH TAKE THE HARD COPY OF ONLY THE FORMULAS just an example if we take the sum of some cell there is a formula like =sum(number of cells and their location) -- Are you =EXP(E:RT) or =NOT(EXP(E:RT