Previous Topic Next Topic

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

Answer 1 / 1
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

Similar discussions

Excel - IF function with multiple words
Nick -
user -

14 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
If cell contains multiple text how to add other cell value?
Iza -
TrowaD -

1 response
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
Excel make cell flash red
hugrl -
Rjc -

13 responses