formula for page to page

Copper Contributor

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.

3 Replies
best response confirmed by Hans Vogelaar (MVP)


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

that worked. Thank you very much for the help

@kylem84 , you are welcome