VBA to create new worksheet and copy formats and values only
I have a worksheet pulling Bloomberg data that is often shared with
non-Bloomberg users. As the data feed is only available from Bloomberg
terminals, I need to copy and past the worksheet to a new tab and have the
data static. I have added a button that will automatically copy and past
the format and values, then name the new tab based on the time it was
created.
Am struggling with the VBA code. Any thought?
No comments:
Post a Comment