The following code creates 3 new worksheets from my master worksheets and renames them based on what is in cell "B4" on Worksheet("Home Page")
I would like to add to this code a line that copies what is in cell "B4" on Worksheet("Home Page") and pastes it in the newly created worksheet ("Home Page").Range("B4").Value2 & " " &("Yearly Lease Order")
Any Ideas?
![]()
Please Login or Register to view this content.
Bookmarks