I have a worksheet with currency and a chart. If I want to copy this to another worksheet and change the values from say USD rates to EUR rates, the chart STILL reads the source data of the first worksheet. This means taking forever manually re-selecting the data source.
Is there a simpler way to clone a worksheet moving all data and chart functionality to a 'new environment'?
Hi smudgepost
you can select the worksheet tab and copy and move it to new location
regards pike
If the solution helped please donate here to the RSPCA
Sites worth visiting;
J&R Solutions - royUK
AJP Excel Information - Andy Pope
Spreadsheet Toolbox
VBA for smarties - snb
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks