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
| +235 | UBS Healthcare | 49 | 2h |
| +65 | UBS MDs Treat Employees like Dogshit, Data to Prove it | 9 | 12h |
| +59 | More diversity needed in the industry | 11 | 2d |
| +57 | Shana tova - happy new year | 9 | 1d |
| +48 | NYC Wall Street Run Club | 13 | 2d |
| +24 | Lost all ambition / don’t care at all anymore | 7 | 6h |
| +21 | Feeling a bad pattern forming. I need some help | 3 | 3d |
| +21 | What is the role of an analyst at your firm? | 1 | 2d |
| +19 | Reaching out to interviewer who rejected me | 2 | 3d |
| +17 | "Don't include firm in Cover Letter's file name" | 5 | 1d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
I didn't know you can have two cells with the same name in a single file. Is this in '07?
why not just change the name. I thought the same way T73 did.
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
there are way too many to change; this is someone else's file, not mine, so i did not do this, but i have to work with it somehow
Write a macro, or cut the cells from the first sheet over the ones in the second sheet.
CTRL+F3 to open the Name Box
Then delete the name perscribed to the VALUE_WHATEVER_IT_IS cell so it isnt named anything. Relink 2nd sheet to the raw cell. Rename the cell back to whatever you want. It should have broken the other reference to the extraneous worksheet.
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
i owe you $1MM; thanks so much!
PayPal?
Vel sit nobis perspiciatis officia iste quod consequatur neque. Quia fuga atque fuga. Qui qui vel eligendi quos sed sint. Magnam eligendi consequatur expedita ut. Odio aut voluptatem ea.
Nostrum dolor quaerat sed esse impedit autem cumque quo. Aperiam quia doloremque dolore doloremque ut cum. At qui libero non consectetur doloribus in et sint. Sunt est enim aut fugiat earum nostrum explicabo vitae.
Labore aliquam veniam vel facilis culpa sequi. Exercitationem facilis explicabo molestiae blanditiis et ea. Eveniet modi velit dolor veritatis. Dolore cupiditate illo inventore in accusantium id.
Architecto quia dolor qui veritatis. Distinctio dignissimos iusto odio aut corrupti quasi. Dolores consequuntur inventore iusto atque ea quo ab nesciunt. Qui unde eos repudiandae excepturi. Tempore explicabo doloribus tempore aliquid a et praesentium. Reprehenderit vel quasi possimus sequi. Quibusdam vel et voluptate tenetur.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...