hi Gurmeet can i have sample file,then it will be easy Have A Nice Time & Enjoy Life
Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Thu, Jan 14, 2010 at 2:19 PM, Gurmeet Singh <gurmeetsingh.meh...@gmail.com> wrote: > Hi, > > Current Situation: > I am currently using a charting software which enables the live price quotes > to be seen in excel, live. > > Solution Required: > I need to tabulate this data on a real time basis, in time spans of 1 min, 5 > min, 30 min, 60 min...so that I can see the progressive data based on the > time > > 10:01 <high> <low> > 10:02 <high> <low> > etc > etc > > Can someone help me with this. > > Thank you > Gurmeet, mumbai > 9920893592 > > > ________________________________ > From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] > On Behalf Of excel-macros+nore...@googlegroups.com > Sent: 12 January 2010 05:05 > To: Digest Recipients > Subject: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 20 > Messages in 10 Topics > > Today's Topic Summary > > Group: http://groups.google.com/group/excel-macros/topics > > Vlookup-Dates [2 Updates] > Dependent Lists [1 Update] > HOW CAN I WORK IN ONE WORKBOOK IN MULTIPLE LOCATION [8 Updates] > altering excel lookup tables [1 Update] > Using macro move sheets from one work book to another work book [2 Updates] > Excel Solver [1 Update] > Export from word to excel [2 Updates] > Code User Laval [1 Update] > Password crecker for Excel workbbok [1 Update] > printing page numbers of worksheets [1 Update] > > Topic: Vlookup-Dates > > Sachin Gohil <sachin.go...@hotmail.com> Jan 11 09:28PM +0530 ^ > > Its very simple data. For every date I want Mon-Sun for that date. > File 1: Date Week15-Jan-09 =vlookup(A2,File2,2,0) which gives #N/A > File 2:Date Week11-Jan-09 11-Jan to 17-Jan12-Jan-09 11-Jan to 17-Jan > 13-Jan-09 11-Jan to 17-Jan14-Jan-09 11-Jan to 17-Jan15-Jan-09 11-Jan to > 17-Jan16-Jan-09 11-Jan to 17-Jan17-Jan-09 11-Jan to 17-Jan18-Jan-09 18-Jan > to 24-Jan19-Jan-09 18-Jan to 24-Jan > Date: Sun, 10 Jan 2010 09:10:23 -0800 > From: alokeshwar.tiw...@yahoo.com > Subject: Re: $$Excel-Macros$$ Vlookup-Dates > To: excel-macros@googlegroups.com > > > > > > Please share the workbook? > > _________________________________________________________________________________________________ > "There are known knowns. These are things we know that we know. There are > known unknowns. That is to say, there are things that we know we don't know. > But there are also unknown unknowns. There are things we don't know we don't > know." > > > > > > > From: Sachin Gohil <sachin.go...@hotmail.com> > To: excel-macros@googlegroups.com > Sent: Sun, 10 January, 2010 7:00:44 PM > Subject: $$Excel-Macros$$ Vlookup-Dates > > > > Dear All, > > > I did a vlookup of dates, but Im getting #N/A. The reason is every date in > excel is tored as serial no. Tried using Date/Date value but it doesnt > work.. > > > > > > > New Windows 7: Find the right PC for you. Learn more. -- > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us in TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > To post to this > group, send email to excel-macros@googlegroups.com > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,500 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > > > > > > > The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. > _________________________________________________________________ > Windows 7: Find the right PC for you. Learn more. > http://windows.microsoft.com/shop > > > > Alokeshwar Tiwary <alokeshwar.tiw...@yahoo.com> Jan 11 08:42AM -0800 ^ > > you can use following function to get date range instead of a vlookup: > > Function GetDateRange(Day1 As Date, CurrentDay As Date) As String > Dim i As Integer, LeftRange As Date, RightRange As Date > If Day1 > CurrentDay Then > DateRange = "#INVALID#" > Exit Function > End If > i = Application.WorksheetFunction.RoundDown((CurrentDay - Day1) / 7, 0) > LeftRange = 7 * (i) + (Day1) > RightRange = 7 * (i + 1) + (Day1 - 1) > GetDateRange = Format(LeftRange, "dd-mmm") & " to " & Format(RightRange, > "dd-mmm") > End Function > > If you want to convert date into Day names, use Text function = > TEXT(YourDate,"ddd") > > _________________________________________________________________________________________________ > "There are known knowns. These are things we know that we know. There are > known unknowns. That is to say, there are things that we know we don't know. > But there are also unknown unknowns. There are things we don't know we don't > know." > > > > > ________________________________ > From: Sachin Gohil <sachin.go...@hotmail.com> > To: excel-macros@googlegroups.com > Sent: Mon, 11 January, 2010 9:28:00 PM > Subject: RE: $$Excel-Macros$$ Vlookup-Dates > > Its very simple data. For every date I want Mon-Sun for that date. > > File 1: > Date Week > 15-Jan-09 =vlookup(A2,File2,2,0) which gives #N/A > > File 2: > Date Week > 11-Jan-09 11-Jan to 17-Jan > 12-Jan-09 11-Jan to 17-Jan > 13-Jan-09 11-Jan to 17-Jan > 14-Jan-09 11-Jan to 17-Jan > 15-Jan-09 11-Jan to 17-Jan > 16-Jan-09 11-Jan to 17-Jan > 17-Jan-09 11-Jan to 17-Jan > 18-Jan-09 18-Jan to 24-Jan > 19-Jan-09 18-Jan to 24-Jan > > ________________________________ > Date: Sun, 10 Jan 2010 09:10:23 -0800 > From: alokeshwar.tiw...@yahoo.com > Subject: Re: $$Excel-Macros$$ Vlookup-Dates > To: excel-macros@googlegroups.com > > > > Please share the workbook? > > _________________________________________________________________________________________________ > "There are known knowns. These are things we know that we know. There are > known unknowns. That is to say, there are things that we know we don't know. > But there are also unknown unknowns. There are things we don't know we don't > know." > > > > > ________________________________ > From: Sachin Gohil <sachin.go...@hotmail.com> > To: excel-macros@googlegroups.com > Sent: Sun, 10 January, 2010 7:00:44 PM > Subject: $$Excel-Macros$$ Vlookup-Dates > > Dear All, > > I did a vlookup of dates, but Im getting #N/A. The reason is every date in > excel is tored as serial no. Tried using Date/Date value but it doesnt > work.. > > > ________________________________ > New Windows 7: Find the right PC for you. Learn more. -- > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us in TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,500 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > > ________________________________ > The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. > ________________________________ > Windows 7: Find the right PC for you. Learn more. -- > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us in TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,500 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > > > > The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. > http://in.yahoo.com/ > > > > Topic: Dependent Lists > > capt edgar <capted...@googlemail.com> Jan 11 07:31AM -0800 ^ > > Hi there > > I have attached a small excel sheet called TESTTHEM which i'm testing > and learning excel simultaneously. On the attached sheet > > under the type column, i have created a dropdown list with some values > in it. If i select a value from the dropdown list say for ex: > Pictures, is it possible to auto-populate certain rows after this > choice i.e. Pictures has been selected. > > The Columns relevent to this row which needs populatng are Test, UAT, > Stage1, Prod1, Prod2, Test Server, UAT Server, Stage1 Server, Prod1 > Server and Prod2 Server. > > The values to populate would be as follows > > Test = Cell Colored to Black( which in out terms means not in use) > UAT = <server name> which i'll fill > Stage1 = <server name> which i'll fill > Prod1 = <server name> which i'll fill > Prod2 = <server name> which i'll fill > Test Server = Pictures Test Server > UAT Server = Pictures UAT Server > Stage1 Server = Pictures Stage1 Server > Prod1 Server = Pictures Prod1 Server > Prod2 Server = Pictures Prod2 Server > > I'm really not sure if i'm asking too much. If anyone is willing to > lead me in the right direction or help, please do so > > regards > > > > Topic: HOW CAN I WORK IN ONE WORKBOOK IN MULTIPLE LOCATION > > Anant Shelke <anant.shelk...@gmail.com> Jan 11 03:29PM +0530 ^ > > Hi, > > I want some help and little bit > challenging > > I WANT TO WORK IN ONE FILE IN MULTIPLE LOCATIONS > AND ALL THE CHANGES MADE BY ALL USERS IT TO BE SAVE IN THAT FILE > IF IT IS POSSIBLE PLS TELL ME HOW CAN I DO IT > > > > -- > Anant Fakt Tumachyasathi > > > > Dave Bonallack <davebonall...@hotmail.com> Jan 11 08:18PM +0800 ^ > > Hi Anant, > I don't think this is possible in XL. It is standard procedure in Access. > Can you use that instead? > Regards - Dave. > > Date: Mon, 11 Jan 2010 15:29:04 +0530 > Subject: $$Excel-Macros$$ HOW CAN I WORK IN ONE WORKBOOK IN MULTIPLE > LOCATION > From: anant.shelk...@gmail.com > To: excel-macros@googlegroups.com > > Hi, > > I want some help and little bit > challenging > > I WANT TO WORK IN ONE FILE IN MULTIPLE LOCATIONS > AND ALL THE CHANGES MADE BY ALL USERS IT TO BE SAVE IN THAT FILE > IF IT IS POSSIBLE PLS TELL ME HOW CAN I DO IT > > > > > -- > Anant Fakt Tumachyasathi > > _________________________________________________________________ > View photos of singles in your area! Browse profiles for FREE > http://clk.atdmt.com/NMN/go/150855801/direct/01/ > > > > SUMIT VYAS <svyas0...@gmail.com> Jan 11 04:21PM +0530 ^ > > Ye To Me Bhi Dhund Raha hu > > > Koi Help Karo Yaar ! > > > > > > gaurav agaskar <gaurav.agas...@gmail.com> Jan 11 05:52PM +0530 ^ > > Try Share workbook function in Tools menu > but it is complicated as well as quit dangerous fuction > becoz unlimited user can work on same sheet at same time > u may facing problem of data loss > > regards > > Gaurav > > > > > > Ramon Diaz <radiaz_1...@yahoo.com> Jan 11 04:50AM -0800 ^ > > Hi dave, > > I also need the said procedure in access, can you help me. > > Thanks in advance. > > Ramesh > > > --- On Mon, 1/11/10, Dave Bonallack <davebonall...@hotmail.com> wrote: > > From: Dave Bonallack <davebonall...@hotmail.com> > Subject: RE: $$Excel-Macros$$ HOW CAN I WORK IN ONE WORKBOOK IN MULTIPLE > LOCATION > To: "excel-macros@googlegroups.com" <excel-macros@googlegroups.com> > Date: Monday, January 11, 2010, 8:18 PM > > > > > Hi Anant, > I don't think this is possible in XL. It is standard procedure in Access. > Can you use that instead? > Regards - Dave. > > Date: Mon, 11 Jan 2010 15:29:04 +0530 > Subject: $$Excel-Macros$$ HOW CAN I WORK IN ONE WORKBOOK IN MULTIPLE > LOCATION > From: anant.shelk...@gmail.com > To: excel-macros@googlegroups.com > > > Hi, > > I want some help and little bit > challenging > > I WANT TO WORK IN ONE FILE IN MULTIPLE LOCATIONS > AND ALL THE CHANGES MADE BY ALL USERS IT TO BE SAVE IN THAT FILE > IF IT IS POSSIBLE PLS TELL ME HOW CAN I DO IT > > > > > -- > Anant Fakt Tumachyasathi > > Browse profiles for FREE View photos of singles in your area! > -- > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us in TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,500 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > > > > SUMIT VYAS <svyas0...@gmail.com> Jan 11 06:31PM +0530 ^ > > Dear > > Local Area Network Working Possibale > > Yes I try & Success > > > > On Mon, Jan 11, 2010 at 5:48 PM, Dave Bonallack > > > > amresh kumar <amreshkushw...@gmail.com> Jan 11 07:26PM +0530 ^ > > offcurse!! > > > > > Ashish Pahuja <pahuja.ash...@gmail.com> Jan 11 08:03PM +0530 ^ > > use Office grove for such purpose or Sharepoint. These two products are > created for such scenarios. > > Thanks & regards > Ashish Pahuja > > > > > Topic: altering excel lookup tables > > bas001 <mxbas...@gmail.com> Jan 11 06:19AM -0800 ^ > > Hello, I need to alter the array of the lookup table e.g. adding a new > column to the array. I am using the lookup name. I there a way to > refresh the name so it it contain the new column . Thanks > > > > Topic: Using macro move sheets from one work book to another work book > > grlinks-karthik <grli...@gmail.com> Jan 11 11:30AM +0530 ^ > > I need to copy the sheets from one work book to another work book, can any > one help is urgent > > I have to work book name called “destination.xls” and “source.xls”, > destination.xls work book contain two sheets name called “sheet1” and > “sheet2” ( source.xls workbook contain only one sheet name called “IT” , > these two sheets copied and move to Source.xls workbook next to “IT” > sheet, I need the Macro for it > > But some conditions are there. > > 1. Macro should be Run while source.xls work book open ( destination > should not be open) > > 2. Both work books will be in different Locations > > 3. Moved sheets should be hidden (only programmer can see the sheets) > > 4. Moved sheets name should be always “sheet1” and “sheet2” > > 5. Suppose “sheet1” and “sheet2” already exists in source.xls work > book then exists sheets should be deleted and moved sheets > (destination.xls work book sheets) should be replaced > Friends your people can able to understand the above, please help me it very > urgent > regards > Grlinks-karthik > > > > DARSHAN K N <darsh...@gmail.com> Jan 11 06:08PM +0530 ^ > > Does any one has macro to rename the tabs > > > I have list of names around 50 in one sheet and i want to rename the tab > according. sometimes i may have less also. > > Thanks and Regards, > > Darshan > > > -- > Dar_ing Darsh..!!!! > > > > Topic: Excel Solver > > Saurabh <dok...@gmail.com> Jan 11 03:01PM +0530 ^ > > pls send that across....i may give sm inputs > > > > > Topic: Export from word to excel > > ashish koul <koul.ash...@gmail.com> Jan 10 10:42PM +0530 ^ > > thanks a lot for the solution can u please make it for notepad files too > > On Sun, Jan 10, 2010 at 3:02 PM, Alokeshwar Tiwary < > > > > Alokeshwar Tiwary <alokeshwar.tiw...@yahoo.com> Jan 11 12:00AM -0800 ^ > > you can use following code if you have to copy a text file into excel: > > Sub CopyTxt() > Application.ScreenUpdating = False > Workbooks.Open "C:\a.txt" > ActiveCell.CurrentRegion.Copy > ThisWorkbook.ActiveSheet.Paste > ActiveWorkbook.Close SaveChanges:=False > Application.ScreenUpdating = True > End Sub > > Another resolution is available here: > http://www.exceluser.com/explore/questions/vba_textcols.htm > > > _________________________________________________________________________________________________ > "There are known knowns. These are things we know that we know. There are > known unknowns. That is to say, there are things that we know we don't know. > But there are also unknown unknowns. There are things we don't know we don't > know." > > > > > ________________________________ > From: ashish koul <koul.ash...@gmail.com> > To: excel-macros@googlegroups.com > Sent: Sun, 10 January, 2010 10:42:29 PM > Subject: Re: $$Excel-Macros$$ Export from word to excel > > thanks a lot for the solution can u please make it for notepad files too > > > On Sun, Jan 10, 2010 at 3:02 PM, Alokeshwar Tiwary > <alokeshwar.tiw...@yahoo.com> wrote: > > Criteria or parameters aren't necessory but it may not be extracting data in > a useful format. >>I have modified the macro to Select and import entire text from a word >> doc. > >>_________________________________________________________________________________________________ >>"There are known knowns. These are things we know that we know. There are >> known unknowns. That is to say, there are things that we know we don't know. >> But there are also unknown unknowns. There are things we don't know we don't >> know." > > ________________________________ > From: Zilla <zill...@gmail.com> > >>> ... > >>> read more » > >>________________________________ > The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. >><><><><><><><><><><><><><><><><><><><><><><> >>HELP US GROW !! > >>We reach over 6,500 subscribers worldwide and receive many nice notes about >> the learning and support from the group.Let friends and co-workers know they >> can subscribe to group at >> http://groups.google.com/group/excel-macros/subscribe > > -- > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us in TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,500 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > > > > The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. > http://in.yahoo.com/ > > > > Topic: Code User Laval > > SUMIT VYAS <svyas0...@gmail.com> Jan 11 11:28AM +0530 ^ > > GREAT ANKUR > > > > > Topic: Password crecker for Excel workbbok > > Nandkumar kakvipure <nandkumar.hindust...@gmail.com> Jan 11 09:49AM +0530 ^ > > Hello Bro, > Please attach File > > > > > Topic: printing page numbers of worksheets > > Dave Bonallack <davebonall...@hotmail.com> Jan 11 10:19AM +0800 ^ > > Hi S, > > Not sure if there's a solution to this. Probably is, but since you're doing > it by macro, I'd just repeat the print command for each sheet. You can put a > single print code-line into a loop if there's lots of sheets. > > Regards - Dave. > >> .CenterFooter = "&P of &N" > >> Thanks in advance, sorry if this is a bit confusing. > >> S. > > _________________________________________________________________ > Search for properties that match your lifestyle! Start searching NOW! > http://clk.atdmt.com/NMN/go/157631292/direct/01/ > > > > -- > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us in TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,500 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > >
-- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us in TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
