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. |
All times are GMT +1. The time now is 03:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com