If statements

L

Lou825

I have a workbook and I want info from sheet 1 to be transferred to sheet 2
on todays date. Is this possible?
 
G

Gord Dibben

Today is April 6th

You want the data tranferred every April 6th of each year or??

Please explain.


Gord Dibben MS Excel MVP
 
L

Lou825

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.
 
L

Lou825

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update several ppt documents from a single excel file 0
Section and Page numbering 0
Page numbering with Merged Document and IF statements 1
Save workbook without shapes 0
Visio: copy text of a master shape to User-define Cells (Variable) 0
need help writing formulas. 1
Using Drop Down list to an If Statement to another Drop Down list 3
=IF function with current date 3

Top