Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default macro copy data wb1 matching date to wb2

Can someone please help,

I need a macro which copies a range of data from one workbook to another.
Wb2 is a monthly summary report which I need to create using the daily data
from wb1. I need the macro to open wb2, then look at the single date on wb1,
find the matching date in a column of dates in wb2, and then copy a range of
data from wb1 alongside the matching date in wb2, if can;t find says date not
found and ends????

thanks
Reply
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
Macro to find matching date and copy values to another sheet Tiger Excel Discussion (Misc queries) 3 August 13th 07 01:45 PM
$%Macro to Copy from one workbook to other when matching data Tiger Excel Discussion (Misc queries) 0 July 30th 07 08:42 AM
macro copy data from one workbook to other by matching date Tiger Excel Discussion (Misc queries) 0 July 27th 07 05:58 AM
Need Macro to copy some date from one Workbook to another. dk_ Excel Discussion (Misc queries) 0 November 10th 06 07:59 AM
Matching data using date criteria... JoeZ Excel Worksheet Functions 1 September 14th 05 02:50 PM


All times are GMT +1. The time now is 11:21 AM.

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

About Us

"It's about Microsoft Excel"