$$Excel-Macros$$ 1Hardcode a cell value to the code(macro code) |||||||||||||| 2code to save only a particular cell value at the time of closing the workbook

Hello all, 1 I need a code which hardcodes a cell value to the macro 2 Is it possible to only save cell contents.In otherwords, I want the contents of the work book to be deleted except a particular cell say a1. Thanks and Regards Bharghav R

$$Excel-Macros$$ Re: 1Hardcode a cell value to the code(macro code) |||||||||||||| 2code to save only a particular cell value at the time of closing the workbook

I have absolutely no idea what your talking about in question 1. Question 2: You need to make a macro that is started every time the workbook is closed. Private Sub Workbook_BeforeClose in your ThisWorkbook sheet. There you can pretty much do whatever you want. I just don't know if you want to

$$Excel-Macros$$ Make a Pivot Table using data from 2 different worksheets

Hi All. I have data in two different sheets. How do i make a Pivot Table using data from 2 different worksheets. Please Help...Very Urgent Regards Prashanth --~--~-~--~~~---~--~~ --

$$Excel-Macros$$ Make a Pivot Table using data from 2 different worksheets

Hi All. I have data in two different sheets. How do i make a Pivot Table using data from 2 different worksheets. Please Help...Very Urgent Regards Prashanth --~--~-~--~~~---~--~~

$$Excel-Macros$$ Re: Make a Pivot Table using data from 2 different worksheets

Hi. Have a look at the solution proposed by Shane Devenshire : http://groups.google.fr/group/microsoft.public.excel/browse_thread/thread/ea 6a31201ae138f9/aedc05161906ef9b?hl=frie=UTF-8q=excel+pivot+table+shane+dev enshire+ Regards. Daniel -Message d'origine- De :

$$Excel-Macros$$ Re: Make a Pivot Table using data from 2 different worksheets

Hi Daniel, Thanks for the Update. However there is no scope for me to pull the data from Access as the data is in excel. Can you please help me to make a single Pivot from the data in 2 different worksheet. Thanks, Prashanth On Tue, Jul 14, 2009 at 5:55 PM, Daniel dcolarde...@free.fr wrote:

$$Excel-Macros$$ Re: Help with Combo Box and Display

Hi Team, Thank you so much Daniel On Tue, Jul 14, 2009 at 1:59 PM, Daniel dcolarde...@free.fr wrote: Hello. Have a look at the attached file. I modified the properties of the combobox of sheet “summary” as follows : ListFillrange : summary!F2:F14 (it may be Monthwise!A3:A15)

$$Excel-Macros$$ attendance sheet

I need to mark attendance for a class running for 3 months. anyone an attendance sheet for 15 people where i can just check on each box if they are present. this should also have a pie chart where each person's participation is shown as a percentage to all

$$Excel-Macros$$ Re: Make a Pivot Table using data from 2 different worksheets

Hi Prashant, Go to Data-Pivot Table and Pivot Chart. Then select the third option : Multiple Consolidation Ranges. This will help if your data have exactly Same no and Name of columns. Regards, Upendra Singh +91-9910227325, +91-9310760597

$$Excel-Macros$$ tranpose question

Hi all, Please find the attachment for my requirement.! Thanks, Skanda. --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free

$$Excel-Macros$$ Re: 1Hardcode a cell value to the code(macro code) |||||||||||||| 2code to save only a particular cell value at the time of closing the workbook

Hi, That could be done by saving A1 to a variable, then clearing the sheet, then re-populate A1. Something like: A = Range(A1).Value ActiveSheet.Cells.ClearContents Range(A1) = A Regards - Dave. Date: Tue, 14 Jul 2009 12:28:09 +0530 Subject: $$Excel-Macros$$ 1Hardcode a cell

$$Excel-Macros$$ how to get the week no in a function

hi can you pls tell me the function to get the week no of a particular date in a cell entry? For example if the date is 12/1/2009, i need the week no in 2009 for this date . thanks --~--~-~--~~~---~--~~

$$Excel-Macros$$ Re: how to get the week no in a function

Hi, Try the following: =WEEKNUM(TODAY()) Regards - Dave. Date: Tue, 14 Jul 2009 19:57:18 -0700 Subject: $$Excel-Macros$$ how to get the week no in a function From: subbu1...@gmail.com To: excel-macros@googlegroups.com hi can you pls tell me the function to get the week no of a