| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy and paste selections and formatting to new worksheet
i have a large range of options on one worksheet. From these options, i would like to use a method of selection like a check box or cell containing qty to note the options to be copied to the next sheet (a quote). IE: options are 1-10, a person selects 1,4,6 and 9....i want these to appear on the next worksheet. I was using simply =IF(A!E1,A!B1," ") but left with blank cells inbetween those that werent selected. Also, the formatting was left behind. Is there any easier way to accomplish this or can i overcome the formatting problem?
Im a novice so any help is really appreciated! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy & paste worksheet with print settings into new worksheet | Excel Discussion (Misc queries) | |||
| How do I copy and paste a worksheet and maintain all formatting? | Excel Worksheet Functions | |||
| copy and paste with multiple selections in Microsoft Excel | Excel Discussion (Misc queries) | |||
| copy and paste with multiple selections in Microsoft Excel | Excel Discussion (Misc queries) | |||
| excel 97: copy and paste values from one worksheet to another worksheet | Excel Programming | |||
Threaded Mode
