copy cells using formula

K

Kashyap

can anyone help me in copying cells from one sheet to another which has
todays date
 
G

Gord Dibben

Formulas can only return values................they cannot copy anything.

Sounds like you need some "linked cells"(see help on linking) formulas on
one sheet to return values from another sheet.

Otherwise some VBA might be your solution.

Provide more details.


Gord Dibben MS Excel MVP
 
K

Kashyap

Hi Gord Dibben,

Actually, I want to copy the rows which contains todays date only from
book1.xls (Sheet1) to book2.xls (Sheet1)

I have 8 columns and the dates are in column B, which contains previous
dates of this month as well. I need to copy only the rows which contain
todays date to book2.xls without opening Book1.xls.

- Kashyap
 

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

Copy addition formula of non-consecutive horizontal cells 2
Need Help with a VBA subroutine 0
Newbie Help - IF Yes No Function 0
Cell data entering slow! 0
Word hyperlinks not working 2
Use TODAY() function as the criteria in a SUMIF formula 1
Excel - Wich Function should I use? 1
copy specific cells from sheets if the information is correct 3

Top