Hello Gurus,
1. Attached is the sample data what we get from the Server
2. The raw data might not have all the LEVELS, where as our report template
in Sheet2 has all the levels
3. Now, I need to pull the data from Raw Tables to Sheet2
4. Here the range may change whenever we refresh the data fo
Hi Gurus,
1. Table shown in the attachment is a HR report needs to be generated every
week.
2. This report basically gives the management Dept wise and Desig wise
headcount
details.
3. The backup data for this report is maintained inAccess 2007.
4. I have more than 100,000 records in the Acces
On Thu, Feb 4, 2010 at 6:46 PM, Ramesh-Hyderabad wrote:
> Hi Gurus,
>
> I have a requirement where I have to check for the minimum date and
> maximum date instances for each employee and concatenate both in a
> single cell as shown in spreadsheet. I have added a spreadsheet as an
> illustration.
>
Hi Ankur,
That working file looks awesomebut i cant see see any data on 'New
Data' sheet. Is there a way i can see the data change according to my
requirement?
Thanks in Advance,
Ramesh
On Jan 7, 4:33 pm, ankur wrote:
> hi sumit
>
> please check the attached file
>
> if any other modificati
Hi Excel Gurus,
Looking for the following actions in excel.
1. As soon as I select an option from the drop down, the cell should be
frozen, rather locked.
2. Further Cell should not allow any user to edit the data
Please let me know if you have any questions.
Regards,
--Ramesh
--
Thanks!!!
Hi Excel Gurus,
Looking for the following actions in excel.
1. As soon as I select an option from the drop down, the cell should
be frozen, rather locked.
2. Further Cell should not allow any user to edit the data
Please let me know if you have any questions.
Regards,
--Ramesh
--
--
Hi Excel Gurus,
Looking for the following actions in excel.
1. As soon as I select an option from the drop down, the cell should
be frozen, rather locked.
2. Further Cell should not allow any user to edit the data
Please let me know if you have any questions.
Regards,
--Ramesh
--
--
which data elements to retrieve?
> Or assigning the macro you already have to a button?
>
> Or do you just want to take the dog for a walk and start over when you get
> back?
> (just kidding)
>
> Paul
>
>
> From: Chanti-Hyderabad
> T
which data elements to retrieve?
> Or assigning the macro you already have to a button?
>
> Or do you just want to take the dog for a walk and start over when you get
> back?
> (just kidding)
>
> Paul
>
>
> From: Chanti-Hyderabad
> T
> Now, what do you need help with?
> > Writing a macro to retrieve data from MS-Access?
> > Defining which data elements to retrieve?
> > Or assigning the macro you already have to a button?
>
> > Or do you just want to take the dog for a walk and start over when you ge
Hi Gurus,
Awaiting for your help..Thanks
On Dec 1, 5:23 pm, Chanti-Hyderabad wrote:
> Hi Excel Gurus,
>
> Hope this new post find you all well.
>
> I would like to add a 'Browse button' (command button) to my excel
> 2007 file, which should pull the data from MS A
Hi Excel Gurus,
Hope this new post find you all well.
I would like to add a 'Browse button' (command button) to my excel
2007 file, which should pull the data from MS Access 2007.
I hope its a bit confusing request, please do let me know if you need
any further clarification.
Regards---
--
--
-- Forwarded message --
From: Chanti-Hyderabad
Date: Wed, Nov 25, 2009 at 9:47 PM
Subject: Copy the formula till end of data without using copy paste every
time we add the add to the sheet
To: MS EXCEL AND VBA MACROS
Hi Team,
Copy the formula till end of data without using
Hi Team,
Copy the formula till end of data without using copy paste every time
we add the add to the sheet.
Please write to me if you are not able to understand the query..
I am herewith attaching a sample file for your easy reference.
Thanks
Ramesh
--
ce you probably aren't processing 40,000 records!
> But left one line in.
>
> comment out (or remove) the line with:
>
> If (R Mod modcnt = 0) Then ...
>
> it should work then.
>
> P
>
>
> From: Chanti-Hyderabad
> To: MS EXCEL A
> Paul
>
>
> From: Chanti-Hyderabad
> To: MS EXCEL AND VBA MACROS
> Sent: Wed, November 4, 2009 7:45:49 AM
> Subject: $$Excel-Macros$$ Re: Segregate data in appropriate sheet with Name
> as sheet name
>
> Thank you so much for your message
quot;)) + 1
> Sheets(Usr).Range("A" & sRows & ":Z" & sRows) =
> Sheets("Data").Range("A" & R & ":Z" & R).Value
> End If
> Next R
> Application.ScreenUpdating = True
> MsgBox "
know that its better to have data in a single sheet in a
> table format than in different sheets so that we can use advanced features
> of excel like pivot tables effectively.
>
> Hemant Hegde
>
> 2009/11/3 Chanti
>
>
>
> > Hi Team,
>
> >> Is there a wa
Hi Team,
>
> Is there a way we can segregate the data depending upon the name
> (column A) to different tabs.
>
> Example
> If it is a macro, and if I run it, the result would be:
>
> Sheet names: “Ramesh”, Ravi”, “Rakesh”, and “Sridhar” and each tab
> would contain the data as per the sheet name.
Hi Team,
Is there a way we can segregate the data depending upon the name
(column A) to different tabs.
Example
If it is a macro, and if I run it, the result would be:
Sheet names: “Ramesh”, Ravi”, “Rakesh”, and “Sridhar” and each tab
would contain the data as per the sheet name.
I hope this
Hey,
Sure, here you go!
Ramesh
On Thu, Sep 10, 2009 at 8:56 PM, vinod rao wrote:
> Hello Ramesh,
> Can you plz put it in my file and send. That will be great.
>
> Regards
>
> On Wed, Sep 9, 2009 at 11:12 PM, Chanti-Hyd wrote:
>
>>
>> {=SUM(IFERROR(1/COUNTIF(r
-- Forwarded message --
From: Chanti
Date: Wed, Sep 9, 2009 at 11:08 PM
Subject: Re: $$Excel-Macros$$ Urgent_ Need ranking formula
To: excel-macros@googlegroups.com
use this formual, i think this should work
={SUM(IFERROR(1/COUNTIF(rankrng,IF(rankrng>E14,rankrng)),0))+1}
{=SUM(IFERROR(1/COUNTIF(rankrng,IF(rankrng>E14,rankrng)),0))+1}
I think this formula should work for you..
Thanks,
Ramesh
On 9 Sep, 21:28, vinod rao wrote:
> Hello Team,
>
> Need ranking formula.See attached, kindly help.
> Regards
>
> Text.xls
> 18KViewDownload
--~--~-~--~~---
use this formual, i think this should work
={SUM(IFERROR(1/COUNTIF(rankrng,IF(rankrng>E14,rankrng)),0))+1}
Use CTRL+SHIFT+ENTER after entering in the required cell instead of "ENTER"
Thanks
Ramesh
On Wed, Sep 9, 2009 at 9:58 PM, vinod rao wrote:
> Hello Team,
>
> Need ranking formula.See attac
Hi Friends,
Challenging request!!!
Need your help in solving a problem pertaining to Graphs in Excel.
*Refer attached sample Excel>>*
Sheet 1>D6> I have given an option to select "Call" or "Put" in D6, Is there
any possibility, where we can select and display Call and Put simultaneously
on the
25 matches
Mail list logo
