| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
IF then write new worksheet/book
I need to be able to do the following:
Search an existing sheet for: Row containing particular cell value = 1 Copy that row Open new workbook(same name as source)+1 (for the first entry) insert worksheet (same name as source) +1 Paste that row( starting from A3) Next entry (that row; that worksheet) goes down one row I have scoured archives, tried all I can do Please hel -- Message posted from http://www.ExcelForum.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I write to a closed work book as a "register" | Excel Discussion (Misc queries) | |||
| I want to write a book on my computer.How can I type? | New Users to Excel | |||
| linking a worksheet to one in another book | Excel Discussion (Misc queries) | |||
| How do I get a Template to write a Book ? | New Users to Excel | |||
| Book on how to write VBA code in a fast/efficient manner? | Excel Programming | |||
![Don Hansford[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
