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: 38
Default Copy data based on month?

I have a spreadsheet(sheet1) that data is inserted throughout the year. I
need a formula or vb code so that by entering a month in cell A1, it will
copy all entries in that month and paste it onto another sheet(sheet2).

Data col= A to E (Col A= date)

Thank you

--
Sophie
 
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
Month based data addition to worksheet Brian Excel Worksheet Functions 1 April 28th 08 05:21 PM
Pull data based on month MikeJ Excel Discussion (Misc queries) 5 January 4th 08 04:50 PM
Pull in a colum of financial data based on the month Bradon Excel Worksheet Functions 1 September 15th 06 07:37 AM
Get Data based on Month and Year karstens Excel Worksheet Functions 1 August 2nd 06 12:42 AM
Referencing data in different worksheet based on month name cosmo_canuck Excel Worksheet Functions 3 August 22nd 05 07:27 AM


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