LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10
Default dates linked to data

I have worksheet one set up as a form to gather information. I have twelve
consecutive worksheets for the months of the year.

I would like to link the data from sheet1 to the appropriate month the data
is for. I am not sure how to do this.

I want all input data from January 1st to January 31st from the form to go
to the worksheet January, February 1st to February 29th to go to worksheet
February, etc.

How can I do this?

Thanks in advance for your help!!!
 
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
How to transpose linked data and keep it linked? Amy Excel Worksheet Functions 3 May 2nd 08 04:11 PM
Counting dates in columns in a linked spreadsheet Bernie R. Excel Worksheet Functions 1 January 31st 08 05:59 PM
Displaying linked data in excel 2007 when linked file is not avail Eng_19 Excel Discussion (Misc queries) 0 December 7th 07 07:27 PM
updating external data sheet causes loss of data on linked pages C_F_Dewey Excel Worksheet Functions 0 August 28th 07 11:48 PM
Dates in Excel linked with Outlook Calendar itsupport@cthomes Excel Worksheet Functions 3 May 19th 05 09:12 PM


All times are GMT +1. The time now is 02:00 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"