Quick Excel question

[FourKicks]

i got it.

H21 and H22 are brothers.

[BG5150]

Pivot table. Use a pivot table!

[BG5150]

(disclaimer: I have no idea what a pivot table even does)

[Smart Actuary]

So OP, who won this contest. My solution is the most elegant, if I should say so myself.

lol

[Ionic Order]

I'm a bit busy right now, but will check all the proposed solutions when I have a chance.

[EvilGenius]

CTL+A
DEL
CTL+S

[Vorian Atreides]

Originally Posted by EvilGenius

CTL+A
DEL
CTL+S
CTRL + ALT + DEL

IFYP. I'm assuming one is working in Windows 3.1, or DOS 5 btw.

[Ionic Order]

Originally Posted by Amphiblitz

Current workbook = workbook A
Temporary new workbook = workbook B

1. Create temporary new workbook B (you probably won't even have to save it).
2. Make a tab in workbook B with the same name as the tab in workbook A that has cells H21 & H22.
3. Cut cell H22 from workbook A and paste into H21 in workbook B.
4. Edit links in workbook A and redirect the reference (change source) from workbook B to workbook A.

I haven't tried it, but I think it will work.

Using your method I was able to have both cell A1 and cell A2 to reference cell H21 in workbook A. And then I can just copy cell H21 from workbook B to workbook A. It works. An elegant way to bypass the reference rules in Excel!

[Smart Actuary]

Originally Posted by HiLine

Using your method I was able to have both cell A1 and cell A2 to reference cell H21 in workbook A. And then I can just copy cell H21 from workbook B to workbook A. It works. An elegant way to bypass the reference rules in Excel!

what?!?!?!?!?!!!!!11111

I beg to differ. My solution was better. Goodbye.

lol

[Amphiblitz]

Originally Posted by HiLine

Using your method I was able to have both cell A1 and cell A2 to reference cell H21 in workbook A. And then I can just copy cell H21 from workbook B to workbook A. It works. An elegant way to bypass the reference rules in Excel!

I'll take an "excellent".