If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Copying to Workbook depending on Criteria?
Hi, wasn't sure whether to post here or the Programming section as I'm fairly new to Excel. I have a spreadsheet (Master Risk Diary) which I have started to create. As I enter information in the spreadsheet I would like this information to copy to another workbook (Rick Risk Diary) multiple times depending on certain criteria. For example if there is a entry in Column A called Rick then information on that row needs to be copied to a different workbook depending on the name located at C:\data\Risk Diary\Rick Risk Diary (and if Ian it goes to Ian Risk Diary etc) all Workbooks are located in the same folder (Risk Diary). but I also need the information to go to a specific worksheet within the Rick Risk Diary Workbook. For example whatever date is in cells B4 to H4 all that row's data needs to be copied to each worksheets month. So to clarify if in Column A it says Rick and in B4 it says 01/01/2006, C4 says 02/06/2006, D4 says 04/08/2006 and E4 says 05/11/2006 etc then that entire rows information get's copied to Rick's Risk Diary and then copied to sheets Jan, June, August and November (or whatever month it says). If it says Ian it goes to a Wb called Ian Risk Diary etc... I hope the above makes sense I'm inputing all the data into one big spreadheet and would like it to auto copy to diff sheets in diff workbooks (unless there's a better way ). I have copied between worksheets before but never between workbooks depending on criteria and I'm just tieing myself up in knots at the moment. If anyone can help or point me in the right direction that'd be great. Thanks Kevin -- Kryptonix ------------------------------------------------------------------------ Kryptonix's Profile: http://www.excelforum.com/member.php...o&userid=28108 View this thread: http://www.excelforum.com/showthread...hreadid=492706 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
HOW DO I SUM TWO CELLS FROM ONE WORKBOOK TO ANOTHER WORKBOOK? | Bill O'Neal | Worksheet Functions | 8 | August 14th, 2009 11:36 PM |
Auto updating a workbook with data from another workbook | Richard | General Discussion | 0 | November 6th, 2005 03:50 PM |
copy a workbook without copying any data | Rusty | General Discussion | 3 | November 5th, 2004 01:33 AM |
Duplicating Excel's Autofilter functionality | rgrantz | Running & Setting Up Queries | 0 | November 3rd, 2004 11:06 PM |
Size of workbook and calculation time huge because of Sumproducts | Hari | General Discussion | 12 | June 19th, 2004 03:31 AM |