| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Copying cells with a macro
I'm working on a spreadsheet that performs some calculations and I have a
button that creates and renames a new worksheet if pressed. I need/would like for the same button to also copy some information from this original worksheet into the new sheet if certain conditions exist. For instance, if the button is pressed, a new sheet is opened, renamed and original data is checked to see if the column B value=1. If it does, the next few columns within that row are copied to the new sheet. There may/will also be multiple entries with a 1 in column B and I need all of those entries copied to the new worksheet. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I pause a macro to select specific cells | Excel Worksheet Functions | |||
| Macro to delete data in 'green' cells only | Excel Worksheet Functions | |||
| copying cells from other worksheets | Excel Discussion (Misc queries) | |||
| Copying a workbook with custom toolbar assigned to a macro | Excel Discussion (Misc queries) | |||
| copying text into a macro | Excel Worksheet Functions | |||
Threaded Mode
