$$Excel-Macros$$ Dynamic Ranges with Vlookup

2010-07-09 Thread Ramesh-Hyderabad
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

$$Excel-Macros$$ Re: Request

2010-03-05 Thread Ramesh-Hyderabad
Hi there, One suggestionOffice 2010 is available for free on microsoft official website... http://www.microsoft.com/office/2010/en/default.aspx Thanks, Ramesh On Mar 3, 2:55 pm, sudhir kumar wrote: > Hi Dear all, > > Can any one send me setup of MS office 2010. > It was download from net b

$$Excel-Macros$$ Logical Concatenating

2010-02-04 Thread Ramesh-Hyderabad
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. Request you to look into it and do the needful at the earliest. Wit

Re: $$Excel-Macros$$ Excel Data Automator

2010-01-25 Thread Ramesh-Hyderabad
Hi Paul, I've installed the add-in, but when I select Control Panel, I get an error message "Cannot open key" I'm using XL2007 Regards - Ramesh On Jan 24, 12:34 pm, Dave Bonallack wrote: > Hi Paul, > I've installed it on my own laptop at home.  I am the only user, and don't > have to log in. How