formula for page to page

[kylem84]

I am needing help to figure out how to take a number from sheet one and have it automatically populate into a cell on another sheet in the same workbook.

example:  SHEET 1cell A6 we have 22 pcs. I like to auto populate that number to sheet 2 cell B5

Any help with this would be greatly appreciated. I have tried the help tab but don't know how to word the search to find what I am needing.

[#2 · Accepted solution]

@kylem84 

Stay on Sheet2 cell B5. Start typing equal sign ("="), when click on Sheet1 cell A6. Enter.

[#3]

that worked. Thank you very much for the help

[#4]

@kylem84 , you are welcome