LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 110
Default How to Automatically transfer specific Data from Sheet 1 to Sheet

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copying Data from one sheet to another sheet on a specific day Gav123 Excel Worksheet Functions 0 May 1st 07 10:17 AM
create a formula in one sheet that would read data from separate sheet automatically QD Excel Discussion (Misc queries) 0 December 8th 06 04:17 AM
How do I Automatically open a sheet so it shows a specific tab or. mayala33 Setting up and Configuration of Excel 2 August 25th 06 06:36 PM
can entered data in sheet 1 be automatically pasted in sheet 2 Adnan Jahangir Excel Discussion (Misc queries) 1 February 23rd 06 10:06 AM
Transfer data from sheet to sheet Jenn Excel Discussion (Misc queries) 4 January 20th 05 03:07 PM


All times are GMT +1. The time now is 06:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"