$$Excel-Macros$$ Tip: How to use excel

Hello Group, I have a tip to share regarding reducing the file size which consists of one or more pivot tables. The option in the pivot table for "Save source data to file" should be unchecked and "Refresh data when opening the file" should be checked. Also, by default "Number of items to retain

Re: $$Excel-Macros$$ "Excel 2007 Power Programming with VBA" by John Walkenbach.

I've got a few ebooks on VBA with MS Excel though not the specific book you mention. If you can use ebooks I can mail them to you. Anand On Mar 24, 12:59 pm, rf1234 rf1234 wrote: > Dear Nani > Check This Link > Outhttp://www.angelfire.com/biz7/julian_s/julian/julians_macros.htm > > this link pr

Re: $$Excel-Macros$$ "Excel 2007 Power Programming with VBA" by John Walkenbach.

Nani Please search www.Edcomp.com for various computer books or www.ebookee.com so that you can get your book VIJAY KUMAR -- -- Some important links for excel users: 1. Follow us on TWITTER

$$Excel-Macros$$ Question about QueryTable

In VBA is there a way to create a dynamic QueryTable? I have a website to which I need to post different variables. When the webpage returns, I need to import a table into a worksheet then post another parameter and then import those results, etc. Is there a way to do this? --

$$Excel-Macros$$ Group Data

Hi, I have a spreadsheet with the following columns: Item # 1 to 1000 Account Number alphanumeric 20 characters long Amount 1 Amount 2 Period 1 Period 2 Data is currently sorted by Amount 2 ( largest to smallest). There are multiple entries for the same account number What I want to do is now

$$Excel-Macros$$ Group Data

Hi, I have a spreadsheet that has the followin columns. It has about 1000 rows. Item #> 1 to 1000 Id Number ===> -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :

$$Excel-Macros$$ Group Data Together

Hi, I have a spreadsheet with the following columns: Item # ID Number -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Fa

$$Excel-Macros$$ Insert Coloured Row VBA Code - MS Excel - Slight change in Code?

Hi, I have the below VBA code that inserts a coloured row based on a changing value in Cell 'C3' What I want to do is to have the macro let the user input the cell ref themselves of 'Range("c3").Select' bit of the code. How can I change the below code to help me do this? Sub Insert_row() Dim Num

Re: $$Excel-Macros$$ Macro

Sorry for that i have atteched two samle files. On Thu, Mar 25, 2010 at 10:20 AM, Suryaprasad wrote: > Hi Sreejith, > > Can we have a Sample File for our reference. > > Thanks > Surya > > On Tue, Mar 23, 2010 at 6:05 PM, sreejith k.s > wrote: > >> Hi Guys, >> >> I need help from you guys, >>

$$Excel-Macros$$ Re: VBA Array Statistics (Min, Max, Sum, Avg, StdDev, etc)

I figured out how to get basic statistical data out of a 1-dimensional Array in VBA. It is actually pretty simple for 1-dimensional arrays just using the built-in worksheet functions. For example, if you have 1000 results in a 1-dimensional array called Results_Array [Dim Results_Array (1 to 1000

Re: $$Excel-Macros$$ VBA VLookup dates

Dave, Appreciate the effort - thanks a lot. I started to think of another way around the problem but that's stumping me as well... Sub Test() Dim lookFor As Range Dim rng As Range Dim col As Integer Dim found As Variant If Range("A2") = "" Then Range("H2") = "" Else: Set lookFor = Sheets("Acce

$$Excel-Macros$$ Date based Triger for a Macro

Dear Group, Is it possible to trigger a macro on a specified date , even if that excel file is not opened Regards Sathish Jalendran The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and

Re: $$Excel-Macros$$ How to seaprate contents

use text to column in data menu On Wed, Mar 24, 2010 at 8:23 PM, Harpreet Singh Gujral < harpreetguj...@gmail.com> wrote: > Hi Group, > > I have a cell that contains more than one email address, the idea is to > seaprate them from one another through a loop. Example: > > Cell A1 has the following

Re: $$Excel-Macros$$ How to seaprate contents

Hello Dear, Have a look on attached workbook. Hope it Will Help Happy to Help :) Shyam On Thu, Mar 25, 2010 at 9:53 AM, Harpreet Singh Gujral wrote: > Hi Group, > > I have a cell that contains more than one email address, the idea is to > seaprate them from one another through a lo