Adding ws information to cell in new wb & saving with ws name

  • Thread starter Thread starter Jodie
  • Start date Start date
J

Jodie

I am trying to select cells in one workbook with multiple sheets and enter
them into multiple workbooks which would each be named and saved with the
same name as the worksheet they came from in the old workbook.

For example, the first worksheet in workbook "Trollie" is named "White". I
am opening another workbook (previously created, named "UDF") and copy cells
c79,c80,c81,c88,c89,c91,and c95 of "Trollie" into cells in column A of "UDF".
I then want to save "UDF" with the name "White" (as in the name of the
worksheet in "Trollie"). I need to do this with each worksheet in the
workbook "Tollie". Can anyone please help with this?
 
Thank you Joel. I tried it and it saved copies of the UDF with file names
equal to the sheet names in the Trollie workbook. However, the UDF files do
not have the cell information from the Trollie workbook. How can I get the
specified cells from the Trollie workbook to each of the new UDF files?

One more thing... I am also trying to populate cell A1 in the new UDF files
with the sheet names of the Trollie workbook. Would you know how to make
that happen?
 
You forgot the "dots" in front of the Range calls (for Column C) in your
"To" section (so they reference back to your With statemen)....

..Range("C79") = sht.Range("A1")
..Range("C80") = sht.Range("A2")
..Range("C81") = sht.Range("A3")
..Range("C88") = sht.Range("A4")
..Range("C89") = sht.Range("A5")
..Range("C91") = sht.Range("A6")
..Range("C95") = sht.Range("A7")
 
Joel, I switched them as you indicated and it is still not populating the
cells in the UDF files with the information from the Trollie workbook. I
don't get an error, it just doesn't do anything.

Rick, I tried with the second leading dot and I get an error.
 
Rick, I tried with the second leading dot and I get an error.

**Second** leading dot??? In the "To" section that Joel posted, he omitted
the leading dot altogether... all I was doing was noting that. If you put
the leading dot in on your own, then you were not suppose to put another one
in as a result of my posting... as I said, I was just correcting an omission
in Joel's message that I thought might possibly have given you a problem.
 
Sorry for the confunsion guys. I did have just one leading zero and it was
not bringing over the cell information. Would either of you know why?
--
Thank you, Jodie


joel said:
Rick had two dots in front of RANGE. There should only be one dot.
Click to expand...
VBA Code:
Click to expand...
 
Sorry again... I meant to say Sorry for the confunsion guys. I did have just
one leading dot in front of Range and it was not bringing over the cell
information. Would either of you know why?
 
That works! Thank you Joel, for all of your help. I also figured out how to
get the sheet name in cell A1.
 
Back
Top