Forum Discussion
Solved
Simple macro
How can i write a simple macro to allow me to change data in my spreadsheet to display on a graph?
for example have 10x2 would display as 2, 10x3 would display as 3, 10x4 would display as 4 etc
Not quite sure I comprehend what you're trying to do.... Is it something like this (see attached .xlsx)?:
Not quite sure I comprehend what you're trying to do.... Is it something like this (see attached .xlsx)?:
Matt
Yes it is basically my values on a report sheet will be as in the middle column on the left, what i want it to show on the data sheet i use to produce the graphs will be as in the right columns.