I'm trying to copy a sample worksheet from one workbook to another workbook
to pull in certain data into a new format. When I do this, it just
references the information in the old workbook instead of the new workbook.
Is there a constant that I can put in so that is doesn't name the workbook in
the files I'm originally referencing, but instead from the new workbook,
worksheet I'm trying to reference? Hope I'm making sense.
Bookmarks