Re: $$Excel-Macros$$ Chart Update Within Date Data Range

Dear Guillett Sir I am confused about this code,I put this code but what changes in sheet,I am not under stand.Pls in attached sheet solved problem if possible.I think in to cell from date & Last date input through data validation & when I change range date then update chart between that date range

$$Excel-Macros$$ I need help on a macro which extracts rows which have a 7 digit number in a column.

For ex i have thousands of records in which one col has 7 digit number in many rows. I need to extract only rows having that 7 digit number. That number has digits 0-9. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANN

$$Excel-Macros$$ macro for detecting date in row

Hi All, I'd like to have a macro that will detect curent date (eg in column "H") then copy all all columns from "A" to column "H" (column "H" excuded so range A:G) and paste all these column as value Thanks Pawel -- Join official facebook page of this forum @ https://www.facebook.com/discussexc

$$Excel-Macros$$ Re: Rek : Need CRM Administrator (Salesforce)

Hi Ayush Pls ban this user. On Monday, 13 August 2012 21:48:23 UTC+5:30, sudheer sudheer wrote: > > *Hi* > > *Need* > > *Role: CRM Administrator (Sales force)* > > *Duration: 1 Year* > > *Location: Austin, TX* > > *Job Specific * > > *Job Specific Required education & experience* > > · High

RE: $$Excel-Macros$$ Power pivot

Noorain bhai, She is asking about Power pivot. Not power point. If you have some material on Power pivot , would be helpful . Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: 13

Re: $$Excel-Macros$$ Power pivot

http://msdn.microsoft.com/en-us/library/office/gg619397.aspx http://www.gaelduhamel.com/tag/power-pivot/ http://msdn.microsoft.com/en-us/LIBRary/gg670985 On Mon, Aug 13, 2012 at 6:55 PM, rekha siri wrote: > hi Team, > > Please share if anyone is having PPT tutorial on Power pivot, usuage of >

$$Excel-Macros$$ Re: want to show always last date in date range in chart X-Axis

Hi Divaker, Can you plz share ur work book with group. regards prince On Thursday, 9 August 2012 19:17:50 UTC+5:30, Divaker Pandey wrote: > > Hi Expert, > > can any one help me to show last available date in chart -xaxis range. > > > Divaker > -- Join official facebook page of this forum @ h

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

I have a "solution" that I use. I place most of the files in network locations, so they are backed up regularly. Where necessary, SHORCUTS are created to utilize these files. It has some limitations, since I could not use the Group Policy approach (thank you I.T.) It consists of (4) files.

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

Hi Paul/Friends, I would like to use this concept for my personal computer. I knew very well that It is going to be tough job but as many experts are part of this group, I hope someone would definitely try to get answer. Let me know if you need more information on same. Please find the attached sh

$$Excel-Macros$$ Re: want to show always last date in date range in chart X-Axis

One way is to display every value on x axis. But this will work only for limited values on x. Means your date range is below 20 or 30. Here you have to format the x axis. Select the scale tab. set the minor unit = 1 and major unit = 1. Another way is to display the max date above or some where

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

I've worked through quite a bit of this. Spent MANY hours trying to work it out. There's LOTS of things to consider. #1.. is this for personal use, or for many people in an office? 1a)  If it is an office, is there an I.T. department that controls PC and Windows configuration? Windows has a "Gr

$$Excel-Macros$$ Re: What is the future of VBA?

Comparing to Programming languages, application packages do have a long life. Still, why do you worry, about the future of VBA. Softwares are born, evolve & become obsolete over a period of time. But software concepts, which have deep foundation in physical sciences & mathematics do have a lon

Re: $$Excel-Macros$$ Chart Update Within Date Data Range

Sub namechart() For Each c In ActiveSheet.ChartObjects c.Name = InputBox("Change the chart name " & c.Name) Next c End Sub Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: amar takale Sent: Monday, August 13, 2012 1:58 AM To: excel-macros@googlegroups.com Subj

$$Excel-Macros$$ Power pivot

hi Team, Please share if anyone is having PPT tutorial on Power pivot, usuage of sparklines/slicer in Excel 2010. Thanks, Rekha -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accura

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

Magnesh and Paul I think you could put an excel file (or a shortcut to one), in the startup folder. have an on open macro in the sheet to record the opening time. Then have a before close macro to record the time and save itself. My only concern would be whether Windows kills excel before the s

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

This is going to be a tough one. It involves access to the Windows environment. I REALLY hope someone has an alternative, but I think you're going to have to write some  VBscript files that run at Windows Login and Logout that will make entries to a log file.   Paul

$$Excel-Macros$$ Need your help

Hi Friends, Please help me on issue below. *Issue :-* I need such excel file which can automatically stored login time with date and logout time so that I could able to analysis for how much time my computer was switched on/in use. For example, If I login by the time *7:00:00 AM* and logout on *1

Re: $$Excel-Macros$$ Fwd: Data Entry - Need insert rows when i press enter button

Dear Friends, Please help me, after i updated the cell C17 the cursor should go to the update button so that i dont use mouse to update please please help me Thanks N.Sundarvelan 9600160150 On Mon, Aug 13, 2012 at 3:46 PM, Sundarvelan N wrote: > Hello Friends, > > Some how i finished my proje

Re: $$Excel-Macros$$ Re: Sorting & v-look up issue - reg.

Hi Very Limited Knowledge of Excel as compared to most others. I use Excel 2003. What I did was to add another column with the formula =text(C2,"") C2 is the date column. (I converted 05.04.2012 into a proper date format first). The above formula gave me a month like "April". Then used

Re: $$Excel-Macros$$ Re: Sorting & v-look up issue - reg.

Hi Very Limited Knowledge of Excel as compared to most others. I use Excel 2003. What I did was to add another column with the formula =text(C2,"") C2 is the date column. (I converted 05.04.2012 into a proper date format first). The above formula gave me a month like "April". Then used

Re: $$Excel-Macros$$ Fwd: Data Entry - Need insert rows when i press enter button

Hello Friends, Some how i finished my project. Last one help to finish my project. My task is after i passedcorssed the cell C17 the cursor should go to update button, please help me as soon as possible. Thanks N.Sundarvelan 9600160150 On Sat, Aug 11, 2012 at 4:02 PM, David Grugeon wrote: >

Re: $$Excel-Macros$$ How to use data of one column by identifying available parentheses ) (

Hi David, A sample file has been shared with you Regards Shekhar Sharma On Wed, Aug 8, 2012 at 4:45 PM, David Grugeon wrote: > Post a sheet with a sample of the data (at least 20 rows). then we can > test our formulae. > > > On 8 August 2012 20:35, Shekhar Sharma wrote: > >> Guyz, >> >> Can y

$$Excel-Macros$$ FW: Join request for MS EXCEL AND VBA MACROS [{ENLaooEF--yUGE3Irl00}]

From: MS EXCEL AND VBA MACROS [mailto:excel-macros+subconf...@googlegroups.com] Sent: Monday, August 13, 2012 11:32 AM To: Azeem Quraishi (HAB5) Subject: Join request for MS EXCEL AND VBA MACROS [{ENLaooEF--yUGE3Irl00}] We received your request to join excel-macros