Copying cells if criteria is met

Closed
IanHeradien Posts 1 Registration date Monday November 23, 2015 Status Member Last seen November 23, 2015 - Nov 23, 2015 at 03:38 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Nov 24, 2015 at 09:19 PM
Hello,


I have multiple sheets with sheet 1 as the main sheet for entering data.
A cell for entering a order number
Cells for entering invoice no.'s for each store.
(Which coppies to the rest of the sheets. The above I've figured out with using: =IF(Sheet1!B3="","",Sheet1!B3).
but now I need to know how add total boxes into the main sheet and it automatically adds the number of boxes into the other sheets.

Please would be thankfullgreatly
Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Nov 24, 2015 at 09:19 PM
Not 100% sure exactly what you asked, but would not sum formula work for you
0