If statements
in [General]
|
From: Lou825 on 6 Apr 2010 15:55 I have a workbook and I want info from sheet 1 to be transferred to sheet 2 on todays date. Is this possible?
From: Gord Dibben on 6 Apr 2010 16:03 Today is April 6th You want the data tranferred every April 6th of each year or?? Please explain. Gord Dibben MS Excel MVP On Tue, 6 Apr 2010 12:55:01 -0700, Lou825 <Lou825(a)discussions.microsoft.com> wrote: >I have a workbook and I want info from sheet 1 to be transferred to sheet 2 >on todays date. Is this possible?
From: Lou825 on 6 Apr 2010 16:46 Sorry about that. On sheet 1 I have conditional formatting that will change the color of a cell on TODAY() and I want the row with the cell that changes to be copied to another sheet. "Gord Dibben" wrote: > Today is April 6th > > You want the data tranferred every April 6th of each year or?? > > Please explain. > > > Gord Dibben MS Excel MVP > > On Tue, 6 Apr 2010 12:55:01 -0700, Lou825 <Lou825(a)discussions.microsoft.com> > wrote: > > >I have a workbook and I want info from sheet 1 to be transferred to sheet 2 > >on todays date. Is this possible? > > . >
From: Lou825 on 6 Apr 2010 22:52 Maybe I should explain what I'm trying to do a little better. I have dates in cells in column C and a conditional format that will change the color of that cell when the date in the cell is past today's date. I would like for the info in the row of the cell that was changed by the format to be copied into a different sheet. So if C8 is changed can the info in A8, B8, and C8 be copied to the next worksheet. I hope this makes sense and helps "Gord Dibben" wrote: > Today is April 6th > > You want the data tranferred every April 6th of each year or?? > > Please explain. > > > Gord Dibben MS Excel MVP > > On Tue, 6 Apr 2010 12:55:01 -0700, Lou825 <Lou825(a)discussions.microsoft.com> > wrote: > > >I have a workbook and I want info from sheet 1 to be transferred to sheet 2 > >on todays date. Is this possible? > > . >
|
Pages: 1 Prev: I cant select rows or columns Next: How to records that the date field = todays date in VBA |