Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copying Data from one sheet to another sheet on a specific day | Excel Worksheet Functions | |||
create a formula in one sheet that would read data from separate sheet automatically | Excel Discussion (Misc queries) | |||
How do I Automatically open a sheet so it shows a specific tab or. | Setting up and Configuration of Excel | |||
can entered data in sheet 1 be automatically pasted in sheet 2 | Excel Discussion (Misc queries) | |||
Transfer data from sheet to sheet | Excel Discussion (Misc queries) |