Copying cells from on row in one wkbk to scattered cells in anthr

M

Memphis

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
 
M

Memphis

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying cells from one workbook to another with many sheets 2
Arrays and scattered cell values or another way? 16
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
copying cells from one wkbk to another 1
VBA - Copying a Certain Colored Row to Paste in Another Worksheet 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Reinstate formulas in specific cells 2
Excel Add ^ to a row of cells containing letters 3

Top