$$Excel-Macros$$ Re: excel vba userform using & data store in access database

2015-09-25 Thread Nasir Saikh
Tick on below and click ok try after. Or if getting error after that then share Access or excel

$$Excel-Macros$$ Re: EXCEL FILE WITH MACRO TO GENERATE SUMMARY REPORT

2015-09-09 Thread Nasir Saikh
Dear Siraj, Can you please share a sample which type summary you required. On Thursday, September 10, 2015 at 9:33:09 AM UTC+5:30, Siraj Momin (BHOG) wrote: > > Deal all > > > > Do any body have sample excel file with macro to generate summary report. > Which calculates the data > > > >

$$Excel-Macros$$ help required to assign number value

2015-09-09 Thread Nasir Saikh
Hi Experts, I need a formula to assign number value example is given below where i need is if the value is max then assign 4, below that 3, below that 2, below that 1 Value 1000 1 100 10 required 43 1 2 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in E

$$Excel-Macros$$ Re: I need macro to send bulk mail with 5 Attachment through outlook

2015-08-13 Thread Nasir Saikh
Hi Veer there is already a post in this group which will solve your query... please search On Friday, August 14, 2015 at 8:47:38 AM UTC+5:30, Veer Dhadra wrote: > > Dear friends, > > If someone created such kind of mail sending macro please send to me. > > > Regards//Harish Kumar > -- Are yo

$$Excel-Macros$$ Re: Need help to split numbers available in the last

2015-08-05 Thread Nasir Saikh
Thanx a lot mandeep its working. On Wednesday, August 5, 2015 at 1:05:03 PM UTC+5:30, Nasir Saikh wrote: > > Hi, > > Please help me out to split numbers from a cells if the numbers available > in the last then. > > Example attached. > > Thanks. > > -- Are you

$$Excel-Macros$$ Need help to split numbers available in the last

2015-08-05 Thread Nasir Saikh
Hi, Please help me out to split numbers from a cells if the numbers available in the last then. Example attached. Thanks. -- 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/d

$$Excel-Macros$$ Re: Conditioning formating problem with first weekday

2015-06-12 Thread Nasir Saikh
which excel version you are working As later 2010 and 2013 there is one formula which is networkdays.int On Friday, June 12, 2015 at 12:07:30 PM UTC+5:30, Maciej Piotrowicz wrote: > > hello Experts > > While using conditioning formating on dates with option next week in > default excel has sunday

$$Excel-Macros$$ Re: VBA code question !!!

2015-06-12 Thread Nasir Saikh
Mandeep, Write a code for error value and execute that code if found any error for example on error resume macrocode On Friday, June 12, 2015 at 11:27:05 AM UTC+5:30, Mandeep Baluja wrote: > > Question mentioned is in between the code > > Sub Get_unique_pincodes() > > With ActiveSheet > lr = A

$$Excel-Macros$$ Want to create a sharepoint site.

2015-06-06 Thread Nasir Saikh
Hi Guys, Can anybody help me out to create a sharepoint website from the msaccess. That anyone can access the data from my access database. Please help Regards Nasir Shaikh -- 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 Faceb

$$Excel-Macros$$ Re: I need a excel where users can add data but cannot delete.

2015-06-04 Thread Nasir Saikh
Thank you so much Ashish and Paul, Trick working both of your guys. Query is solved now On Wednesday, June 3, 2015 at 12:16:44 PM UTC+5:30, Nasir Saikh wrote: > Hi Experts, > > I need to help to make a excel database. > In the excel file I need, users can open the sheet and add th

$$Excel-Macros$$ I need a excel where users can add data but cannot delete.

2015-06-02 Thread Nasir Saikh
Hi Experts, I need to help to make a excel database. In the excel file I need, users can open the sheet and add the data write anything and can be save. But they cannot delete anything from the excel once they kept any value in the excel. Regards Nasir Shaikh -- Are you =EXP(E:RT) or =NOT(EX

$$Excel-Macros$$ Re: Help required for MS- Access application.

2015-05-18 Thread Nasir Saikh
Brother the code which you have given it is for excel. I am talking about MS Access On Monday, May 18, 2015 at 1:42:30 PM UTC+5:30, Nasir Saikh wrote: > Hi Experts, > > I want to split table from main table with their names available in column > > For example. > > I h

$$Excel-Macros$$ Re: Help required for MS- Access application.

2015-05-18 Thread Nasir Saikh
Thanks dude but I need code to make separate sheet for each LOB as these needs to assign work to each individual. On Monday, May 18, 2015 at 1:42:30 PM UTC+5:30, Nasir Saikh wrote: > Hi Experts, > > I want to split table from main table with their names available in column

$$Excel-Macros$$ Re: Help required for MS- Access application.

2015-05-18 Thread Nasir Saikh
Accident Health Liability Personal Accident Miscellaneous Miscellaneous MiscellaneousLiabilityPersonal AccidentPersonal AccidentLiabilityMiscellaneous - PackageMiscellaneous - Package On Monday, May 18, 2015 at 1:42:30 PM UTC+5:30, Nasir Saikh wrote: > Hi Experts, > > I want to sp

$$Excel-Macros$$ Re: Need a code to paste snapshot on outlook mail.

2015-05-18 Thread Nasir Saikh
Thank you Mandeep i did it. On Friday, May 15, 2015 at 9:01:41 PM UTC+5:30, Nasir Saikh wrote: > Hi Experts, > > Here can you please help me out with the code to paste snapshot on outlook > mail. > > Thanks > > Nasir Shaikh > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT))

$$Excel-Macros$$ Help required for MS- Access application.

2015-05-18 Thread Nasir Saikh
Hi Experts, I want to split table from main table with their names available in column For example. I have a database in the database name available A,B,C,D,E only then the data for each should be make separate. Thanks in advance. Regards Nasir Shaikh -- Are you =EXP(E:RT) or =NOT(EXP(

$$Excel-Macros$$ Need a code to paste snapshot on outlook mail.

2015-05-15 Thread Nasir Saikh
Hi Experts, Here can you please help me out with the code to paste snapshot on outlook mail. Thanks Nasir Shaikh -- 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/discussexc

$$Excel-Macros$$ Re: Conditional Formating Problem

2015-05-14 Thread Nasir Saikh
PLEASE SHARE SAMPLE FILE On Thursday, May 14, 2015 at 3:24:47 PM UTC+5:30, ali abbas wrote: > Dear All. Hope u r all well. > > I have two column with numbers. My requirement is if one column values is > greater than other then greater values color should be red and its smaller > values color is

$$Excel-Macros$$ Re: Do while loop question

2015-05-14 Thread Nasir Saikh
Hi, You need to change formula with below... =IFERROR(ROUND((E6/G6*100),0)/100,0) On Monday, January 12, 2015 at 7:45:03 PM UTC+5:30, liron glam wrote: > > > I have big data file on excel, the file has 6930 rows and 8 columns, the 8 > column has percents (0%, 4%, 16%, 18%, 19% and etc..) >

$$Excel-Macros$$ Re: Query to retreive data

2015-04-28 Thread Nasir Saikh
r8 Pramod access is very easy and taking very less time than excel on huge data you can use it till 2 GB data. On Tuesday, April 28, 2015 at 11:34:45 AM UTC+5:30, Mandeep Baluja wrote: > My mmaster file is large and i just want to do lookup on my sheet from > master file without opening my mast

$$Excel-Macros$$ Re: Business Analyst Role

2015-04-28 Thread Nasir Saikh
Hi Pankaj, As per your post I am looking for job and I think I ll suitable for your expectation. And I have lot of experience about Advance Excel, VBA , Access but I have worked on SQL but I know some queries like select , update, append, make table, ,making database, new users access etc. I

$$Excel-Macros$$ Re: Query to retreive data

2015-04-28 Thread Nasir Saikh
Hi Mandeep As per my suggestion you can use table link vloopup as I am using and it is working fine. Example is given below. Sub LoopUp() Dim iRow As Integer Dim MaxRow As Long MaxRow = ActiveSheet.Range("A" & Rows.Count).End(xlUp).Row Range("B2").FormulaR1C1 = "=VLOOKUP(RC[-1],'C:\Users\n025

$$Excel-Macros$$ Re: freshser exel traning

2015-04-21 Thread Nasir Saikh
Dude Join classes to become Expert in MS Office. On Tuesday, April 21, 2015 at 1:16:37 PM UTC+5:30, yadramharsana wrote: > > Dear, > all of my freds are the list .I ma a fresher of exel & i know > the basic of exel but i want to know about mis executive report and full > knowle

$$Excel-Macros$$ Want to Close file in second if not in use.

2015-04-16 Thread Nasir Saikh
Hi Guys, Please help i am stuck on a code that if nodbody is using excel then the current workbook should close in 10 second with popup of 10,9,8,7,6,5,,4,3,2,1. I have written code and it is working but not understanding that anybody working or not. below is the code. Private Sub ToggleButton

Re: $$Excel-Macros$$ Re: Want to work on single workbook with multiple user at a time.

2015-03-18 Thread Nasir Saikh
it? > > Regards, > > Swapnil > On 18-Mar-2015 4:30 pm, "Nasir Saikh" > > wrote: > >> Dear Anil, >> >> Thanks for your reply but the query have not solved. >> I already given the access to the users but only one user can use at a >> time if

Re: $$Excel-Macros$$ Re: Want to work on single workbook with multiple user at a time.

2015-03-18 Thread Nasir Saikh
Mar 18, 2015 at 3:51 PM, Nasir Saikh > wrote: > >> Anybody Can help me out on this >> >> On Wednesday, March 18, 2015 at 1:46:59 PM UTC+5:30, Nasir Saikh wrote: >>> >>> Hi, >>> >>> I need help to make a excel workbook which should use b

$$Excel-Macros$$ Re: Want to work on single workbook with multiple user at a time.

2015-03-18 Thread Nasir Saikh
Anybody Can help me out on this On Wednesday, March 18, 2015 at 1:46:59 PM UTC+5:30, Nasir Saikh wrote: > > Hi, > > I need help to make a excel workbook which should use by more than 5 > members at a single time and all can save the workbook at a time. > > Please hel

$$Excel-Macros$$ Want to work on single workbook with multiple user at a time.

2015-03-18 Thread Nasir Saikh
Hi, I need help to make a excel workbook which should use by more than 5 members at a single time and all can save the workbook at a time. Please help me i am stuck on it Regards Nasir Shaikh 876702 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:I