SirJB7,
Sorry work has had me occupied lately and I haven't had time to reply. I appreciate you taking steps to improve the macro, unfortunately I need it to recalculate the entire sheet like it did originally. My main sheet does other calculations of which the end result is what I need...
Thanks for the warm welcome guys!
SirJB7 your posted spreadsheet seems to go above and beyond what I was able to comprehend. I am doing this mostly as an intellectual exercise and to help a friend, so I am going to spend a while going over your code to figure out what each line does.
I am...
Hey guys I have a question. Here is the rundown of what I am trying to do.
1. I want to copy a specific cell from Sheet1 let's say A1
2. Then I want to paste the 'value' not formula of that cell on Sheet2 starting at A1.
3. Next I want to refresh the data values on Sheet1 (it does...