Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
copy data from master sheet new
my sheet1 is master sheet where data related to all continent is entered. e.g.
A B C D ............. BY 1 America US Big 1 8-Jun-09 2 Europe Britain Big 3 9-Jun-09 3 America Canadan Medium 7 9-Jun-09 Here column BY contains data entry date. I have another sheet (named today data file) which should contain all data which has been entered in master data sheet today only.I am using today () function.Now in master sheet if america is found in column A, I want to copy entire row data (today's data i.e. row3) to today data file say to A15 across row. If Europe is found in column A in master sheet,i want to copy entire row to today data file say to A200 across row. Today's data sheet sholud not contain yesterday's data or earlier one. Pls help. i dont want to use macro. Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy data from master sheet | New Users to Excel | |||
copy data from master sheet | Excel Discussion (Misc queries) | |||
copy data from master sheet | Excel Discussion (Misc queries) | |||
copy data from master sheet | Excel Discussion (Misc queries) | |||
How do I copy specific information from a master sheet? | Excel Worksheet Functions |