$$Excel-Macros$$ duplicating data

I have 2 excel worksheets, both are in different formats. Both will contain the same data but spread across different parts of the worksheets. if I have filled in the data for 1 worksheet, how can i automate this data to be filled into the other worksheet? --

$$Excel-Macros$$ date filtering by number

I have a spreadsheet that lists, with start dates in column C. I would like to be able to automatically number the dates which fall within the same week example, if start date falls within this week, column D will be labelled as 1. if start date falls within next week, column D will be labelled a

$$Excel-Macros$$ date filtering by number

I have a spreadsheet that lists, with start dates in column C. I would like to be able to automatically number the dates which fall within the same week example, if start date falls within this week, column D will be labelled as 1. if start date falls within next week, column D will be labelled a

$$Excel-Macros$$ filtering dates within this week

I have a series of dates. How can i filter dates that are within this week? thanks --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and T

$$Excel-Macros$$ matching and finding data

hi, how do i match columnA in spreadsheetA with columnB in spreadsheetB to find the value in columnD of spreadsheetB ? --~--~-~--~~~---~--~~ -- Some important links for excel users: 1.

$$Excel-Macros$$ importing a table in powerpoint to excel

how do i go about importing a table in powerpoint to excel? --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downl

$$Excel-Macros$$ rota template

Anyone has a template which allows to plan rota of 20+ people operating 2 shifts? --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Tex

$$Excel-Macros$$ Re: column chart

Hi, if you could merge the y axis for both sides and teach me how to do it in excel 2003 will solve my problem. Thanks venkatesh srinivas wrote: > Hi Lynn! > > Please let me know if the below mentioned file solves our problem > > > > > On 8/18/09, Lynn wrote: > >

$$Excel-Macros$$ column chart

i have the following columns - dates - no. of boxes packed - no. of boxes to be packed. how do i do a column chart which compares the no. of boxes packed vs to be packed ? --~--~-~--~~~---~--~~ -

$$Excel-Macros$$ can't find project or library

encounter this error : can't find project or library when try to run a code which contains Calendar1.Value any help? --~--~-~--~~~---~--~~ -- Some important links for excel users: 1.

$$Excel-Macros$$ synchronising data in 2 excel files

i have 2 identical excel files updated by 2 different people. How do I synchronise the data into 1 file? --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA

$$Excel-Macros$$ Re: Daniel -- calendar pop-up

any help?? On Jul 7, 8:55 pm, Lynn wrote: > error --> missing MS calendar control 8.0 > pls help > > Thanks > > On Jul 7, 3:45 am, y2 kx wrote: > > > > > Hello Mr.CA Narendra Ashara, > > Try this link very simple.. > > >http://sudhirsuni

$$Excel-Macros$$ Re: colour coding alternate weeks

are you there??? On Jul 20, 10:58 pm, Lynn wrote: > could you teach me how you came up with this formula? > thanks > > On Jul 20, 1:40 pm, Ashish Pradhan wrote: > > > > > Hello Lynn > > > In Conditional Formatting, you can use the formula (Please select the

$$Excel-Macros$$ Re: colour coding alternate weeks

could you teach me how you came up with this formula? thanks On Jul 20, 1:40 pm, Ashish Pradhan wrote: > Hello Lynn > > In Conditional Formatting, you can use the formula (Please select the entire > column or rows where you have the dates) > > =MOD((1+INT(($A2-DATE(YEAR($

$$Excel-Macros$$ colour coding alternate weeks

I am entering dates every week into a spreadsheet. How can I automatically colour a date on week 1 as red and week 2 as green for all alternate weeks? --~--~-~--~~~---~--~~ -- Some imp

$$Excel-Macros$$ Re: You may not use references to other worksheets or workbooks for Conditional Formatting criteria.

Any help? Lynn wrote: > i am already using named ranges. > still does not work, something must have went wrong when i copy from 1 > workbook to this one?? > > On Jul 18, 11:32 pm, "Daniel" wrote: > > You can use named ranges to bypass the impossibility. However,

$$Excel-Macros$$ Re: You may not use references to other worksheets or workbooks for Conditional Formatting criteria.

t;other" workbook has to be opened. > HTH > Daniel > > > > > -Original Message- > > From: excel-macros@googlegroups.com [mailto:excel- > > mac...@googlegroups.com] On Behalf Of Lynn > > Sent: samedi 18 juillet 2009 15:48 > > To: MS EXCEL AND

$$Excel-Macros$$ You may not use references to other worksheets or workbooks for Conditional Formatting criteria.

i have copied my worksheet to another workbook. while trying to perform conditional formatting i got this error: You may not use references to other worksheets or workbooks for Conditional Formatting criteria. how to fix this? --~--~-~--~~~---~--~~ --

$$Excel-Macros$$ Calender Control

any idea why Calender Control cannot be clicked? --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at ht

$$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: about VBA in MS project

any help? On Jul 2, 11:54 pm, Lynn wrote: > how can this be done in MS project? > > On Jul 1, 8:09 pm, Dilip Pandey wrote: > > > > > Hi, > > > Check the attached file.  Overdue tasks/ projects will be highlighted > > automatically. > > > Thanks,

$$Excel-Macros$$ error : can't find object or library

I got this error : can't find object or library whenever i try to enter some information into a cell. can someone advise how to get raid of it? thanks --~--~-~--~~~---~--~~ -- Some

$$Excel-Macros$$ Re: Daniel -- calendar pop-up

roups.com [mailto:excel-mac...@googlegroups.com] > > On Behalf Of Daniel > > Sent: 05 July, 2009 9:35 PM > > To: excel-macros@googlegroups.com > > Subject: $$Excel-Macros$$ Re: calendar pop-up > > > Look at the attached file. > > Daniel > > > > -Mess

$$Excel-Macros$$ macro to delete all labels

hi, anyone has a macro to delete all labels in a spreadsheet? --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins d

$$Excel-Macros$$ timeline

how can i draw a monthly timeline in excel to visually tell the recipient where are we now --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Vide

$$Excel-Macros$$ Re: calendar pop-up

nu when the file is opened. It is removed when the file > closes. > > Daniel > > > > > -Message d'origine- > > De : excel-macros@googlegroups.com [mailto:excel- > > mac...@googlegroups.com] De la part de Lynn > > Envoyé : samedi 4 juillet

$$Excel-Macros$$ Re: calendar pop-up

this is not what I wanted. I do not want the calendar to be shown on the excel sheet. It should only pop-up when I click on the cell which I need to enter a date. Pls review this. thanks On Jul 4, 2:52 am, Dilip Pandey wrote: > Hi Lynn, > > Calender control has been explained in the

$$Excel-Macros$$ calendar pop-up

How can I have a calendar pop-up box for me to make date selection when I click on a cell? --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Vide

$$Excel-Macros$$ Re: about VBA in MS project

t; dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 110062 > > > > On Mon, Jun 29, 2009 at 7:34 PM, wrote: > > > Any help? > > > -Original Message- > > From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] > > O

$$Excel-Macros$$ displaying an empty cell

I used to reference cells in our worksheets (e.g. =Sheet1!C6). if Sheet1!C6 is empty i will get a 0 in my cell. How can i get a blank cell if Sheet1!C6 is an empty cell? thanks --~--~-~--~~~---~--~~ -

$$Excel-Macros$$ about VBA in MS project

Hi, I have not been successful in getting this from MS project group. I would like to write a vba code to highlight tasks that has been overdued for 1 week. any help here? thanks in advance --~--~-~--~~~---~--~~ ---