Defeat VLOOKUP on save (????)

B

bobmc

Board Regular
Joined
Mar 13, 2002
Messages
142
Prices change...so when I save a "bid" worksheet that references VLOOKUP (which resides on a different workbook), I want the values to change to fixed, rather than remain relative to the VLOOKUP doc. That way, after prices change, I can look up an old bid and it will still have the prices quoted at the time of original entry.

Any suggestions?
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
You must log in or register to reply here.

Similar threads

B
  • Question
Paste results of Filter Function in place, or in separate sheet
Replies
0
Views
89
bertible
B
D
  • Question
Copying/Pasting images to the correct row/column location between two different workbooks
Replies
0
Views
233
doctorhifi
D
D
  • Question
VBA for Copying & pasting (with resizing) Named ranges from one workbook to another
Replies
3
Views
539
doctorhifi
D
B
  • Solved
Worksheet Change - multiple Loops in one sub
2
Replies
13
Views
204
mumps
mumps
I
  • Question
VBA - Copy Sheet from a workbook saved as a date - paste to specifically named sheet in another workbook based on the date
Replies
2
Views
204
Insurance Dave
I

Forum statistics

Threads
1,214,646
Messages
6,120,717
Members
448,985
Latest member
chocbudda

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top