| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy row content from one worksheet to another, if a condition met
Hi,
I need to be able to copy content from one worksheet (contests) to another worksheet (current) if Status = Open. On Contests column A is Status. If Column A1 = Open, I want to copy content from B1:I1 to worksheet Current starting in spot A1 and continue to end of list. Basically I have a bunch of contests I am tracking on worsheet Contests. I only want contest that are "Open" to appear on my current sheet. I have to update this information weekly so I am wondering what is the easiest way to get things done and will have a minimal amt of upkeep |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy content of coloums between different workgroups | Excel Worksheet Functions | |||
| copy comment content to cell content as data not as comment | Excel Discussion (Misc queries) | |||
| Copy row based on cell content | New Users to Excel | |||
| copy data from 1 worksheet to another based on a condition | Excel Worksheet Functions | |||
| How do I copy a cell (content AND format) from one worksheet to a. | Excel Worksheet Functions | |||
Threaded Mode
