Hi guys
Trying to sort some data on seperate sheets. I have a table of data on each sheet and need to find the average value from the last 10 cells in column G on a sheet called "0.3lpm" and paste into a sheet called "comp" (which could be the active sheet).
Thanks!!
banana97,
This would be one way of doing it. Probably the hard way, but at least it will get you started.
Please Login or Register to view this content.
Sincerely,
Jeff
I couldn't get that to work.
If i just record a macro I get this:
So basically while in the active sheet (which i've called comp) I'm going to another sheet called 0.3lpm and selecting the last 10 rows of column G then doing the average.Please Login or Register to view this content.
How can I modify the macro to automatically pick the last 10 rows in column G on sheet 0.3lpm?
Thanks for the help!
banana97,
Try this. It is setting up a formula to be placed in cell A1 on sheet Comp. It creates a formula that sums the last 10 cells of Column G and divides by it by 10.
If you want this to calculate everytime a change is made to 0.3lpm you will need to put something like this Sheet 0.3lpm object in the VB editor.Please Login or Register to view this content.
Hope this works for youPlease Login or Register to view this content.
Worked like a dream!
Thank you very much!
Banana97,
Great! I'm glad it worked. Creating a formula just took a little more thought on my end so answering your question ended up being a benefit to me.
Glad I was able to help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks