Hi Everyone hope you all all safe at this difficult time worldwide.... i have a chart with data showing my diabetes blood test results and averages, but on a separate data sheet i also have cells that automatically works out how many tests are in a certain range (i.e. lower than 4, between 4 and 12 and then above 12) these change every time i add data to the data sheet. what i want to do is transpose these cells onto the chart sheet so they change when ever i enter data, is this possible. Thanks in advance and keep safe.
Bookmarks