Hi I was hoping to get some help on some code that will update my scatter plot on click of button on Excel sheet. I'm using Excel 2007. Data is on Pivot Tables and the row range will always change.
Basically I have Scatter plot that collects data from two separate Pivot Tables on two sheets...
Thanks shades I'm still on step one.
Remind me how your answer helps my question did you not understand it if not then say so and I can try to clarify instead of pointing me to a link on how to ask questions.
Hello all I was wonders if anyone knows how to do the following I know very little about code and all I really know is to copy and past it into Excel so any help would be appreciated.
I would like to copy information from several spreadsheets lets say from Sheet 1 to Sheet 200 all data to be...