| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying cells from on row in one wkbk to scattered cells in anthr
I need to bring over from a workbook (8500BasicInfo.xls) details found in a
row 1 (A1:M1) and paste the cells onto a different workbook (8500InputForm.xls) where the destination cells are scattered in different locations throughout different Sheets. For example I need A1 from 8500BasicInfo.xls to be copied and pasted on to 8500InputForm.xls Sheet1 Cell B3 and A2 copied and pasted onto Sheet2 Cell A1. I then need to save the newly copied information as a new workbook. What i am doing is creating documents with basic identifying information about the case and then other users enter their findings on this document. I will need to repeat this for every row (about 100 rows) in 8500BasicInfo.xls I will be repeating this every month as new cases come up. so if any one here knows of a way to also save the file by assigning an Automaticly created file name to it, for example their account number and last name of the cells I have in the row I copied from. Thank you |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sorry for the Duplicate Q.
I got some funky error when I posted the question and i thought it did not
post, so i ended up posting again, see similar posting. Memphis "Memphis" wrote: I need to bring over from a workbook (8500BasicInfo.xls) details found in a row 1 (A1:M1) and paste the cells onto a different workbook (8500InputForm.xls) where the destination cells are scattered in different locations throughout different Sheets. For example I need A1 from 8500BasicInfo.xls to be copied and pasted on to 8500InputForm.xls Sheet1 Cell B3 and A2 copied and pasted onto Sheet2 Cell A1. I then need to save the newly copied information as a new workbook. What i am doing is creating documents with basic identifying information about the case and then other users enter their findings on this document. I will need to repeat this for every row (about 100 rows) in 8500BasicInfo.xls I will be repeating this every month as new cases come up. so if any one here knows of a way to also save the file by assigning an Automaticly created file name to it, for example their account number and last name of the cells I have in the row I copied from. Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying cell info from one sheet to another in the same wkbk | Excel Discussion (Misc queries) | |||
| copying cells from one wkbk to another | Excel Programming | |||
| formula to add cells in multiple shts in the same wkbk | Excel Worksheet Functions | |||
| Checking for Empty Scattered Cells | Excel Programming | |||
| How do I skip blank cells when copying over a range of cells? | Excel Discussion (Misc queries) | |||
Linear Mode
