Copy figure to new datasheet - use new values

**chickentoaster** · 04-23-2019, 01:06 AM

Hello everybody,
I am trying to copy a figure from a template Excel worksheet to another sheet with new data.
It all has same size, same details, but the figure uses the values from the old sheet as in

"=DATENREIHE('C:\Users\xxx\Documents\...\[filename.xls]Calc'!$L$1;'C:\Users\xxx\Documents\...\[filename.xls]Calc'!$A$2:$A$122;'C:\Users\xxx\Documents\\[filename.xls]Calc'!$L"

And the reference is also inside the selected data rows, so just deleting it is a loot of work and I could just set up the figure anew.
Is there a way to resolve this?

Thank you!

**Roel Jongman** · 04-23-2019, 03:10 AM

deleting does not have to be done manually but can be done with the find and replace function (CTRL+H)

put the part to delete in the Find field and leave replace sheet blank

FIND: 'C:\Users\xxx\Documents\...\[filename.xls]Calc'!

It will remove all those text strings if you leave replace blank and the formula will start refering to the sheet it is on.

**chickentoaster** · 04-23-2019, 07:12 AM

Thank you for your answer! This may be part of a solution, but unfortunately it is still not suitable... Because I would have to click on every of the 10 graphs in the plot and change the Data column manually...

**chickentoaster** · 04-23-2019, 07:15 AM

I found the solution!

You can copy the whole data sheet by right clicking it in the bottom datasheet browsing bar and click on "Move or copy". If I copy the sheet this way, and not only the values and plot, the references will be updated. Now I just copy all the data into that sheet and I am done in 10s per plot!

Copy figure to new datasheet - use new values

LinkBack

Thread Tools

Rate This Thread

Display

Copy figure to new datasheet - use new values

Re: Copy figure to new datasheet - use new values

Re: Copy figure to new datasheet - use new values

Re: Copy figure to new datasheet - use new values

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] copy rows out of a datasheet based on a code number and past these rows in a new sheet

Copy Data from multiple sheets to Main datasheet

VBA for display Various Datasheet data in Masterdatasheet when we choose datasheet name

[SOLVED] How to insert sub-caption for figures? figure 1, figure 2-a, figure 2-b, figure 3, ...

[SOLVED] Changed userform combobox to listbox, unable to get userform to retrieve datasheet values

VBscript function to copy rows from datasheet in qtp to an external excel sheet

Dynamically copy only unique values to new datasheet?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions