Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
AutomaticallyTransfer data to a sheet 1 to sheet2 by month.
I want to work with two sheets.
I have a sheet"1" column (a1) "names", column (b2) "dates" Example a1 John Mcarther ....1-15-07 David Chrysler.....1-06-07 Chris Bobby .......2-15-07 Dan John.............3-15-07 b1 1-15-07 1-06-07 2-15-07 3-15-07 What i want to do in Sheet 2 have. Column A1 Named (january) and B2 (february) and B3 (March) and so on thru the whole year. When i enter the name and date in sheet one.. I want that data to automatically be transfered in the appropriate "month column" in sheet 2. example a1 (January) John Mcarther David Chrysler b1 (Februrary) Chris Bobby C1 (March) Dan John. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do copy "sheet1!A1+1 in sheet2 to sheet 3 and get "sheet2!A1+ | Excel Discussion (Misc queries) | |||
How do I pick the same cell in sheet 1!, Sheet2! and just drag | Excel Worksheet Functions | |||
Cross sheet references (=Sheet2!B4) | Excel Discussion (Misc queries) | |||
transfer cell $ amount to other sheet month-to-month without overc | Excel Discussion (Misc queries) | |||
can I transfer data from sheet 1 to sheet2? | Excel Discussion (Misc queries) |