If statements

  • Thread starter Thread starter Lou825
  • Start date Start date
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?
 
Today is April 6th

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

Please explain.


Gord Dibben MS Excel MVP
 
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.
 
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
 
You must log in or register to reply here.

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

Excel Move or Copy Stopped Working? 0
VBA to automatically cut, paste entire row based on date input and delete row 0
HELP HELP HELP Deadline coming. Linking Worksheets 3
Nested If 5
Excel Formula - Count Dates from another Sheet 8
Coding issue with Excel 2003 1
formula help PLEASE 5
Excel VBA to go to specific sheet & cell in the current workbook not working. 2

Back
Top