Moving Value Sheet to Sheet

[Adam.Effinger]

So, I'm working to create a macro that will keep track of test cases fo
my company. I would like to know the following:

If I want to take a value (% done) and move that to the results page
How would I do that? I know I can use =sum(stuff) on the same page, bu
how do I change from one page to another

 

[Luke M]

You can either have the macro do a copy and paste if you need everything
transferred, but it you just need the value, the quicker way it to do a
direct callout like this:

Sheets("Sheet2").Range("A3").Value = _
Sheets("Sheet1").Range("C6").Value