| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy cells using formula
can anyone help me in copying cells from one sheet to another which has
todays date |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
copy cells using formula
Hi,
maybe this =Sheet1!A1 Mike "Kashyap" wrote: can anyone help me in copying cells from one sheet to another which has todays date |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
copy cells using formula
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 On Fri, 7 Nov 2008 04:48:01 -0800, Kashyap wrote: can anyone help me in copying cells from one sheet to another which has todays date |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
copy cells using formula
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 "Gord Dibben" wrote: 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 On Fri, 7 Nov 2008 04:48:01 -0800, Kashyap wrote: can anyone help me in copying cells from one sheet to another which has todays date |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Cells Formula | Setting up and Configuration of Excel | |||
| Using formula to copy cells | Excel Discussion (Misc queries) | |||
| copy formula with same cells involved | Excel Discussion (Misc queries) | |||
| Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
| copy cells with formula without references | Excel Worksheet Functions | |||
Linear Mode
