$$Excel-Macros$$ Prepare break database(HTML)

2010-07-17 Thread sachin or
Hi all, Please help me prepare a Break database. Requirements: 1) Limited access to database(admin access). 2) All users should should have access to the database(user access) I.e. Share the file 3) When they enter the user I'd it should automatically take the time and enter their user I'd and ti

$$Excel-Macros$$ Re: Create a Unique Name List

2010-07-17 Thread Michael Hayes
If you can copy everything to the new column, the rest of it can be done easily with a pivot table. On Jul 17, 12:31 am, Scott wrote: > Hi, > I'm trying to create a list of unique names from a list of names (some > duplicates)  that exist on 15 different sheets within a spreadsheet. > So I want t

$$Excel-Macros$$ Personal Macro giving serious problem to excel

2010-07-17 Thread Milind Sulakhi
Hi, I am using office 2007 & have recorded Macro with relative reference for formatting number in Personal Macro workbook as below : Sub numberformat() ' ' numberformat Macro ' numer comma format ' ' Keyboard Shortcut: Ctrl+q ' Selection.numberformat = "#,##0_);(#,##0)" End Sub Sometimes it

$$Excel-Macros$$ How to automate copy from sheet to sheet, wait for data upload and copy results again ?

2010-07-17 Thread Subu
Dear Members I have a sp sheet for picking up stock market data from the web. When a ticker symbol is entered into the "input dashboard" of this workbook, this workbook picks up some stock market data from the web and provides results. As of now this could be done manually ...i.e. entering symbol

$$Excel-Macros$$ Time Slot from Time

2010-07-17 Thread Saurabh Patel
Dear All, Need help in attached excel file. Regards, Saurabh Patel DISCLAIMER:The information contained in this electronic message and in any attachments to this message is confidential, legally privileged and intended only for the person or entity to which this electr

$$Excel-Macros$$ Create a Unique Name List

2010-07-17 Thread Scott
Hi, I'm trying to create a list of unique names from a list of names (some duplicates) that exist on 15 different sheets within a spreadsheet. So I want the unique list to copy to a new sheet in column A and I want to be able to sum the values (in this case hours) for each of those people on those

RE: $$Excel-Macros$$ Excel macro undefined variable

2010-07-17 Thread Dave Bonallack
Yes, I think you're right about variables being zero by default. Dave. > Date: Fri, 16 Jul 2010 12:37:57 -0700 > Subject: Re: $$Excel-Macros$$ Excel macro undefined variable > From: ottl...@gmail.com > To: excel-macros@googlegroups.com > > Thanks. The Find option did not show any prior instanc