| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro that runs when the value in A1 has a certain property
Basic Question: How can I create a macro that tests whether the value in
column C is €œX€ and if it is, run a separate macro. Detailed Question: At the moment, I have a macro that names the workbook after a date value in Sheet1!A1. I want my macro to take that value and search in Sheet2, column A for that date, and then test whether the text value in column C is €œTue.€ If it is Tue, then I want to copy and paste the prior weeks numbers into a new worksheet. Example: The value in Sheet1!A1 is 10-Jan-06 and since that is a Tuesday, rows 2-Jan-06 to 8-Jan-06 are copied and pasted to a new worksheet. Does anyone have any ideas how to do that? Date No. Day 2-Jan-06 281 Mon 3-Jan-06 282 Tue 4-Jan-06 283 Wed 5-Jan-06 284 Thu 6-Jan-06 285 Fri 7-Jan-06 286 Sat 8-Jan-06 287 Sun 9-Jan-06 288 Mon 10-Jan-06 289 Tue 11-Jan-06 290 Wed |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA macro runs fine, but freezes if I try to do ANYTHING else whileit runs | Setting up and Configuration of Excel | |||
| Why macro runs on the same sheet? | Excel Discussion (Misc queries) | |||
| One macro runs then it auto runs another macro | Excel Discussion (Misc queries) | |||
| Which Macro Runs...? | Excel Discussion (Misc queries) | |||
| Macro runs in source , but not when in Personal Macro Workbook | Excel Programming | |||
Threaded Mode
