Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
keeping a toolbar attached to a workbook | Excel Discussion (Misc queries) | |||
Updating master workbook from source that may/may not exist | Excel Worksheet Functions | |||
Copying a workbook with custom toolbar assigned to a macro | Excel Discussion (Misc queries) | |||
Unprotect Workbook | Excel Discussion (Misc queries) | |||
Copying From workbook to workbook | Excel Worksheet Functions |