LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 84
Default Creating a macro to paste in a specific cell

Hi,

I'm trying to work out if it's possible to create a macro that will find a
cell from one workbook and identify that as the "range" cell so it can paste
information into relative cells.

For example. I have this information being updated daily.

A1 B1 C1 etc
15/01/2008 data 1 Data 2 etc

And I want the a macro that will search another workbook to find the Date
15/01/2008 and make this the range cell so that I can copy and paste B1, C1
etc into the next cells.?

Can this be done?

Thanks
Carl
 
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
Issue with creating a specific macro where two conditions exist BrianMo Excel Programming 2 September 20th 06 08:34 PM
help creating a macro in excel that opens a specific word document Prohock Excel Discussion (Misc queries) 3 March 30th 06 04:58 PM
A Macro that will cut and paste to specific cell VBA12thRoundDraftPick Excel Discussion (Misc queries) 1 March 31st 05 06:11 AM
Need help with creating a special copy and paste macro Shawn[_8_] Excel Programming 4 July 12th 04 09:15 PM
Macro to Paste to specific line, and continue to Paste each time on next row not over tomkarakowski[_2_] Excel Programming 1 May 28th 04 06:50 PM


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