Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to Copy Selection to new Sheets
Hello All,
I am using Office XP , on Win XP I have the following problem. I have a many rows on Sheet1 (say Master). I wish to copy certain rows to a new Sheet in the same workbook. I need a macro to run after making the selection which should ask me the name for the new Sheet and then copy the contents to the new Sheet. Then another selection will be made and the macro should ask me the name .. so on so forth. In other words, I wish to create many new Sheets from the Master in the same work book. The Selection made would be continous rowsA1:F100 (the first time), A101:F202 (the second time) etc. etc. Can this be achieved? In other words I wish to have many Sheets in the same workbook which is pieces of the Master Sheet. TIA Rashid Khan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selection copy and insert to other sheet (Macro) | Excel Discussion (Misc queries) | |||
Help creating a macro to copy and paste a certain selection | Excel Discussion (Misc queries) | |||
Help creating a macro to copy and paste a certain selection | Excel Discussion (Misc queries) | |||
Help creating a macro to copy and paste a certain selection | Excel Discussion (Misc queries) | |||
Need a macro to Copy a selection and paste into a new email. | Excel Discussion (Misc queries) |