urgent, need help w/excel question!! $1MM to whoever answers it first

i have copied a "Sheet A" from "workbook 1" into "workbook 2". workbook 1 has a cell named "value_begin". workbook 2 has a cell named the same thing, but sheet A is still referencing "value_begin" from workbook 1. how do i get it to reference the "value_begin" in workbook 2?

ANY help would be MUCH appreciated

10 Comments
 

it's just still giving the same data as the previous workbook, and the previous workbook happens to have that particular cell named the same thing as what i need my formula to reference to

 

Use the audit to trail back to the reference cells. make sure there's no Workbook1!value_begin reference. You can always write a quick macro to scan all your cells it WorksheetA and replace any "Workbook1!value_begin" references to "value_begin" reference.

Sub ReplacePainInTheAssReference() Dim bcell as range, i as integer For i = each bcell in selection If instr(1, bcell.formular1c1, "workbook1!value_begin" then bcell.formular1c1 = replace(bcell.formular1c1, "workbook1!value_begin", "value_begin") end if Next i End Sub

 

Sit ab id exercitationem ea. Rerum ratione adipisci eum aliquam. Eos culpa odit autem omnis est. Ut aliquid ullam pariatur fugit. Sit et minima aspernatur nulla ullam.

Fugit officia id sed aut. Excepturi dolores ut amet eius explicabo.

Impedit dignissimos modi architecto soluta corporis deserunt. Necessitatibus occaecati sed qui fugiat rerum et ratione et. Porro quia ut consequatur quam aut dolor. In enim animi id quas id velit id. Rerum ab est ratione perferendis harum. Qui aspernatur aut fuga ullam dolor. Praesentium iusto saepe et fuga ad ullam vel. Natus error adipisci molestiae.

Quas velit beatae aut odit saepe non. Quasi mollitia reprehenderit laboriosam eveniet atque.

Career Advancement Opportunities

November 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 99.0%
  • JPMorgan 01 98.4%
  • Guggenheim Partners 02 97.9%
  • Morgan Stanley 06 97.4%

Overall Employee Satisfaction

November 2026 Investment Banking

  • Moelis & Company No 99.5%
  • Morgan Stanley 02 99.0%
  • Evercore 01 98.4%
  • Banco Santander 04 97.9%
  • BMO Capital Markets 13 97.4%

Professional Growth Opportunities

November 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 99.0%
  • Morgan Stanley 05 98.4%
  • Goldman Sachs 01 97.9%
  • JPMorgan No 97.4%

Total Avg Compensation

November 2026 Investment Banking

  • Vice President (17) $409
  • Associates (58) $261
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (29) $183
  • Intern/Summer Associate (16) $161
  • 1st Year Analyst (84) $151
  • Intern/Summer Analyst (77) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
Secyh62's picture
Secyh62
99.0
3
kanon's picture
kanon
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
Betsy Massar's picture
Betsy Massar
98.9
6
GameTheory's picture
GameTheory
98.9
7
DrApeman's picture
DrApeman
98.9
8
dosk17's picture
dosk17
98.9
9
CompBanker's picture
CompBanker
98.9
10
Mimbs's picture
Mimbs
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”