$$Excel-Macros$$ Loop and extract part of the data

Resending since I forgot the subject... sorry! Hi, I need some help. I have a long list of customers, and I need to loop through it and extract part of the data. I can not use PivotTables, I need VBA on this. Please find attached a sample model of input/output. This should not be too com

$$Excel-Macros$$

Hi, I need some help. I have a long list of customers, and I need to loop through it and extract part of the data. I can not use PivotTables, I need VBA on this. Please find attached a sample model of input/output. This should not be too complex but I am not very familiar with arrays and loops.

RE: $$Excel-Macros$$ Pivot Table - Prevent to add/remove fields except page field

and just need to check the checkboxes as shown in the solution. -- Thanks & Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On Tue, Apr 13, 2010 at 6:30 PM, Cecilia Chiderski wrote: Hi, I ha

$$Excel-Macros$$ Pivot Table - Prevent to add/remove fields except page field

Hi, I have a sheet with three Pivot Tables. I want to allow the user to select any value on the Page fields, but I don't want the user to: - Add more page fields - Remove the existing page fields - Add/remove any other field in the Pivot Is there any way to prevent the user to do it??

$$Excel-Macros$$ RE: SumProduct in VBA - Error

example to use SUMPRODUCT via VBA, as the image which might help you out. Best of Luck. Thanks & Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 1/29/10, Cecilia Chiderski wrote: Dili

RE: $$Excel-Macros$$ Compare lists and return missing data

9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 1/30/10, Cecilia Chiderski wrote: Thanks a lot Date: Sat, 30 Jan 2010 23:23:47 +0530 Subject: Re: $$Excel-Macros$$ Compare lists and return missing data From: dilipan...@gmail.com To: cecic...@hotmail.com CC: ex

RE: $$Excel-Macros$$ Function to return days by month

excel-macros@googlegroups.com You are welcome Cecilia, Let me know in case if you stuck somewhere in your project. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 1/29/10, Cecilia Chid

RE: $$Excel-Macros$$ Function to return days by month

data, means you should go from top to bottom rather than going towards left to right. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 1/27/10, Cecilia Chiderski wrote: Hi Dilip, p

RE: $$Excel-Macros$$ Compare lists and return missing data

acros$$ Compare lists and return missing data From: dilipan...@gmail.com To: excel-macros@googlegroups.com CC: cecic...@hotmail.com Dear Cecilia, Attached file has been solved per your requirements. Get back to me in case of any queries. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B CO

$$Excel-Macros$$ Compare lists and return missing data

Hi, it's me again... needing some help. Please se attached file for details. I have two lists of resources, and I need a third list showing resources in list 2 but not in 1. THANKS! Cecilia __

RE: $$Excel-Macros$$ Function to return days by month

l.com dilipan...@yahoo.com New Delhi - 110062 On 1/24/10, Cecilia Chiderski wrote: Here we go sumproduct on By Resource. I added two dummy columns, but doesn't hurt. Question: Why if January is not planned, in your formula by month January still shows 1?? (try removing contents

RE: $$Excel-Macros$$ Function to return days by month

ed, if you find this interesting and useful. Let me know in case of any queries. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 1/23/10, Cecilia Chiderski wrote: I need help. I have a

$$Excel-Macros$$ Function to return days by month

I need help. I have a Start Date and End Date, formated as date. I need to calculate the days by month covered by this start/end. Example is attached. Also, based on the days by month, I need to calendarize assignment by resource (see attached file). I CAN NOT use in this model any of the An

$$Excel-Macros$$ Help-Format in hierarchy view

Please, help on the attached (details of what I need is listed in the file). In summary, I need to show in tree view the hierarchical relation between employees. I was able to do it with Index/Match but I would like to use VBA for this. Thanks in advance, Cecilia

$$Excel-Macros$$ Macro to split a master list into three lists

Hi, I need your expertise on this... Example attached. I have a list of resources with different locations. There are 3 possible locations. I need to split the list into three different tables, one per location, and add total on each. Number of resources is not fixed, number of locations is alw

$$Excel-Macros$$ Macro to update another Macro?

Hi, I have an Excel file with a locked VBA code. I need to create in a separated Excel file a Macro to update a Macro stored in this first Excel. I read some useful information in the web, but still can't write the appropriate code to do it. Can somebody send an example?? Thanks, CC