|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to select non-adjacent values in separate worksheets to include in formulas?
Hi there,
I’m having trouble selecting non-adjacent values, on different worksheets in the same workbook, to enter into a formula. After selecting all the relevant cells on both worksheets and pressing Enter, it keeps resulting in a zero! I’ve read that you can make selections on separate worksheets to include in formulas, but I can’t seem to figure out how to do this. Can anyone help me out with this? It would be greatly appreciated. Thanks in advance |
#2
|
|||
|
|||
I assume you are holding down the 'Ctrl' key whislt selecting multiple cells?
|
#3
|
|||
|
|||
Yes, I'd been holding down the Ctrl key, but when it came to the second worksheet, I was clicking on the relevant cells but forgetting to add the comma after each value when it appeared on the formula bar. I've got it to work out now. Thanks.
Well to see I'm a novice!! Cheers |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Copy data from 2 external files into separate worksheets of a third file | kevinbradley57 | Excel Programming | 2 | 05-25-2018 01:12 PM |
Include multiple (but varying in number) Excel rows in each separate email | mrjimi | Mail Merge | 3 | 12-10-2017 09:45 AM |
Insert Row with Command Button Include Formulas and Merged Cells | TileGal | Excel Programming | 12 | 08-30-2017 06:15 AM |
Adding adjacent cells and having the sum appear in two separate places | Seamus Sean | Excel | 4 | 12-11-2016 10:34 PM |
Counting only the unique names in 3 columns on separate worksheets. | Ryga38 | Excel | 1 | 04-15-2016 07:21 AM |