$$Excel-Macros$$ Re: Need Access help

another way select t.name sum(t.count) From ( Write your first qry1 union Write your second qry2 ) as t *Group By t.name* Regards Prince On Friday, July 5, 2013 12:26:48 PM UTC+5:30, Prince wrote: > > > select t.name sum(t.count) > > From > ( > > Select * from qry1 > > union > > select * from

$$Excel-Macros$$ Re: Need Access help

select t.name sum(t.count) From ( Select * from qry1 union select * from qry2 ) as t *Group By t.name* Regards Prince On Friday, July 5, 2013 12:25:30 PM UTC+5:30, Prince wrote: > > Just do this > > > select t.name sum(t.count) > > From > ( > > Select * from qry1 > > union > > select * f

$$Excel-Macros$$ Re: Need Access help

Just do this select t.name sum(t.count) From ( Select * from qry1 union select * from qry2 ) as t Regards Prince On Friday, July 5, 2013 12:02:00 PM UTC+5:30, rk sharma wrote: > > Dear Experts > > > i have two queries in acess 2010 screen shot attached which have data > mention below >

Re: $$Excel-Macros$$ Need Access help

Dear Rakesh, Pl find attached herewith. Warm Regards, Gawli Anil. On Fri, Jul 5, 2013 at 12:02 PM, Rakesh Sharma wrote: > Dear Experts > > > i have two queries in acess 2010 screen shot attached which have data > mention below > > i just want to sum both of two queries. pl help > > query 1

$$Excel-Macros$$ Need Access help

Dear Experts i have two queries in acess 2010 screen shot attached which have data mention below i just want to sum both of two queries. pl help query 1 query 2 name count name count rakesh 1

$$Excel-Macros$$ Need Formula

Hi Team, I need your help to get details with formula in attached file. Rgds, Prabhakar -- 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 c

Re: $$Excel-Macros$$ Re: SAVE As file name

You may click.. https://groups.google.com/groups/opt_out Thanks On 5 Jul 2013 10:51, "R Swarup" wrote: > pl tell how to exit out of this group? > > > On Fri, Jul 5, 2013 at 10:28 AM, sandeep shivpujan singh < > mandy07s...@gmail.com> wrote: > >> Hi, >> >> You can use below code also. I think yo

Re: $$Excel-Macros$$ Re: SAVE As file name

pl tell how to exit out of this group? On Fri, Jul 5, 2013 at 10:28 AM, sandeep shivpujan singh < mandy07s...@gmail.com> wrote: > Hi, > > You can use below code also. I think you want to save a blank sheet with > the required name. > > 1. Code to save one sheet with the data given in cells 2. >

$$Excel-Macros$$ Re: SAVE As file name

Hi, You can use below code also. I think you want to save a blank sheet with the required name. 1. Code to save one sheet with the data given in cells 2. Dim strPath As String strPath = ActiveWorkbook.Path & "\" ActiveSheet.Copy ActiveWorkbook.SaveAs Filename:=strPath & Cells(2, 1) & "-" & Cel

$$Excel-Macros$$ Re: SAVE As file name

Hi You can try this code: Sub SaveFileAs() Dim FName As String Dim FPath As String FPath = ThisWorkbook.Path '"C:" FName = ABC(Range("A2").Value, Range("B2").Value, Range("C2").Value) 'FName = Sheets("Sheet1").Range("A1").Text ThisWorkbook.S

Re: $$Excel-Macros$$ Files / Folders Sharing Query - reg.

To keep in Track, we can add some user environment in filename '= Dim fName As String, fPath as string, fTag as String fPath = "\\your-computer-name\my-shared-folder\" '<-- Set This to Your Full Path Of Your Shared Folder to

Re: $$Excel-Macros$$ Files / Folders Sharing Query - reg.

VBA...given good idea..I havn't tried it. Yet, you can write below code. It will SaveAs your backup file automatically every time you close your main workbook to the destination of your choice by overwriting previous one. Just copy and paste below in "ThisWorkbook" module. Change the path highlight

Re: $$Excel-Macros$$ Error in Excel Report

From: Manoj Kumar To: excel-macros@googlegroups.com Sent: Thursday, 4 July 2013 4:47 PM Subject: $$Excel-Macros$$ Error in Excel Report Dear Expert, Please help to sove my Quiry file attached in mail. i need fill all data with "p" how many count in he

Re: $$Excel-Macros$$ required Result on Conditions

try this code - Sub test() Dim i As Long For i = 3 To Range("AG4").Column Range(Cells(5, i), Cells(5 + Cells(4, i) - 1, i)).Value = "p" Next End Sub see if it helps On Thu, Jul 4, 2013 at 10:18 PM, Anil Kumar wrote: > > -- > *Fr

Re: $$Excel-Macros$$ required Result on Conditions

From: Rakesh Kumar Sharma To: MS EXCEL AND VBA MACROS Sent: Thursday, 4 July 2013 11:42 AM Subject: $$Excel-Macros$$ required Result on Conditions Dear Experts, I want Result on  conditions. Pls find the attachment. -- Regards, Rakesh Kumar Sharma

Re: $$Excel-Macros$$ Problem with searching through rows and their associated columns

can u share the sample file with us Regards Ashish On Thu, Jul 4, 2013 at 7:07 AM, Brian Yam wrote: > Dear All, > > I am new to VBA programming > I happen to need great and urgent help on a project that I am currently > working on > I would like to search through the worksheet, and find "N" or

Re: $$Excel-Macros$$ Functions name in Calculated field of Pivot

Thanks Vijay :) On Wed, Jul 3, 2013 at 10:23 PM, P.VIJAYKUMAR wrote: > Respected Vijay, > > Please find the attached file.You can also search the following links > > http://office.microsoft.com/en-in/excel-help/summary-functions-available-in-pivottable-and-pivotchart-reports-HP005203116.aspx >

Re: $$Excel-Macros$$ Files / Folders Sharing Query - reg.

hey PFA attach file with macro to backup folder. Thanks!! On Thu, Jul 4, 2013 at 6:09 PM, Pravin Gunjal wrote: > Can I get some more suggestions on this topic.. Thanks. > > Regards > Pravin Gunjal. > > -- Forwarded message -- > From: Pravin Gunjal > Date: Thu, Jul 4, 2013 at

Re: $$Excel-Macros$$ Extract Data on basis of different Criterias

delete the columns u don't want using vba On Thu, Jul 4, 2013 at 1:19 PM, SG wrote: > hi Ashish, > > thanks for the help.please help me in result as i want only name & > accuracy to show. > > On Wednesday, July 3, 2013 8:49:33 PM UTC+5:30, ashish wrote: > >> try the attachment . if ur data is i

Fwd: $$Excel-Macros$$ Files / Folders Sharing Query - reg.

Can I get some more suggestions on this topic.. Thanks. Regards Pravin Gunjal. -- Forwarded message -- From: Pravin Gunjal Date: Thu, Jul 4, 2013 at 2:14 PM Subject: Fwd: $$Excel-Macros$$ Files / Folders Sharing Query - reg. To: excel-macros@googlegroups.com Hi Anoop, Thank y

Re: $$Excel-Macros$$ Error in Excel Report

please see the example what i need On Thu, Jul 4, 2013 at 5:02 PM, De Premor wrote: > On cell C5, paste this =IF($B5=C$3,REPT("p",C$3),0) > > Rgds, > [dp] > Pada 04/07/2013 18:19, Manoj Kumar menulis: > > > > > > On Thu, Jul 4, 2013 at 4:47 PM, Manoj Kumar wrote: > >> >> Dear Expert, >> >>

Re: $$Excel-Macros$$ Error in Excel Report

From: Manoj Kumar To: excel-macros@googlegroups.com Sent: Thursday, 4 July 2013 4:49 PM Subject: Re: $$Excel-Macros$$ Error in Excel Report On Thu, Jul 4, 2013 at 4:47 PM, Manoj Kumar wrote: > >Dear Expert, > > >Please help to sove my Quiry file

Re: Message Recall Failure: Recall: $$Excel-Macros$$ Re: Subtract dates

file is not open From: Chandra Gupta Maurya To: excel-macros@googlegroups.com Sent: Thursday, 4 July 2013 2:33 PM Subject: Message Recall Failure: Recall: $$Excel-Macros$$ Re: Subtract dates -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wann

Re: $$Excel-Macros$$ Error in Excel Report

On cell C5, paste this =IF($B5=C$3,REPT("p",C$3),0) Rgds, [dp] Pada 04/07/2013 18:19, Manoj Kumar menulis: On Thu, Jul 4, 2013 at 4:47 PM, Manoj Kumar > wrote: Dear Expert, Please help to sove my Quiry file attached in mail. i need fill all data

Re: $$Excel-Macros$$ Error in Excel Report

Please elaborate some more . Enjoy Team XLS On Thu, Jul 4, 2013 at 4:49 PM, Manoj Kumar wrote: > > > > > On Thu, Jul 4, 2013 at 4:47 PM, Manoj Kumar wrote: > >> >> Dear Expert, >> >> Please help to sove my Quiry file attached in mail. >> >> i need fill all data with

Re: $$Excel-Macros$$ Error in Excel Report

On Thu, Jul 4, 2013 at 4:47 PM, Manoj Kumar wrote: > > Dear Expert, > > Please help to sove my Quiry file attached in mail. > > i need fill all data with "p" how many count in header. > > Regard > Manoj > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,D

$$Excel-Macros$$ Error in Excel Report

Dear Expert, Please help to sove my Quiry file attached in mail. i need fill all data with "p" how many count in header. Regard Manoj -- 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$$ Re: Query in For Each Next

No , It Is not refering each cell in the * Range("A1:D5") *.For getting each cell you have to change the code like *Sub Upper_()* *For Each x In Range("A1:D5").cells* *x.Value = UCase(x.Value)* *Next* * * *Regards* *Prince* On Wednesday, 3 July 2013 10:41:21 UTC+5:30, Prafull Jadhav w

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

Hi Sandeep welcom on group. Regards Prince On Thursday, 27 June 2013 10:57:28 UTC+5:30, sandeep shivpujan singh wrote: > > Hi Everyone, > > I am Sandeep S Singh from India > Hyderabad. I am a Software Engineer > working with Cognizant. I have just now joined this group & It is my first > post.

Message Recall Failure: Recall: $$Excel-Macros$$ Re: Subtract dates

<>

Fwd: $$Excel-Macros$$ Files / Folders Sharing Query - reg.

Hi Anoop, Thank you for valuable information. Is there any option to create a back-up / auto up-dation in some other location, and not in the same folder. Regards Pravin Gunjal. -- Forwarded message -- From: Anoop K Sharma Date: Thu, Jul 4, 2013 at 1:28 PM Subject: Re: $$Excel-

Re: $$Excel-Macros$$ Re: AMC Tracker Sheet

Hi, Thanks for the information but I want Annual Maintainace contract tracker. Regards On Thu, Jul 4, 2013 at 12:33 PM, NKworld wrote: > Hi, > > Download it in Excel Format -* > www.XL.NKworld.in > * > > Thanks >

Re: $$Excel-Macros$$ Files / Folders Sharing Query - reg.

Ok, you can do one thing.. SaveAs your Excel File. While doing this, you see a dialog box. Click on "Tool" drop down near "Save" button and select "General Option". In "General Option" dialog box, check on "Always create backup"...supply password (if you think it is required). Hide this back up fil

Re: $$Excel-Macros$$ Extract Data on basis of different Criterias

hi Ashish, thanks for the help.please help me in result as i want only name & accuracy to show. On Wednesday, July 3, 2013 8:49:33 PM UTC+5:30, ashish wrote: > try the attachment . if ur data is in lakhs best is u use access > > Regards > Ashish > > > > > On Wed, Jul 3, 2013 at 8:42 PM, SG >w

$$Excel-Macros$$ Re: AMC Tracker Sheet

Hi, Download it in Excel Format -* www.XL.NKworld.in * Thanks On Wednesday, July 3, 2013 6:54:24 PM UTC+5:30, vikas khen wrote: > > Dear all, > > Does anybody have AMC Tracker Template/Sheet ? > > > Regards >