Data Swapping on the fly

[jabryantiii]

In trying to better this project i am working on, and getting great help from this forum, I have a new question. Is it possible to swap data in a cell on the fly either through a button, check box or radial?

What I have is a "bid" area on a work book that is supplied info based on the user choice. So what happens is the user goes to a part page, picks and item, and then clicks a button to add the item to a bid sheet. From there the corresponding cells are auto filled via VLOOKUP. The item that is transferred is the part number; also this is what I would like to “swap” on the fly. The part numbers have generic descriptor (which I already have stored on another sheet along with the rest of the data that is auto filled via VLOOKUP) but because the user is transferring that data for VLOOKUP to work I am not sure it can be done.

[jabryantiii]

I have another idea on this issue. Would setting up a worksheet that gathers all the VLOOKUP data, including the “generic” descriptors that I am trying to swap be better for swapping data the way I am asking?

What I was thinking is basically having two sheets that look the same, one hidden one not, with the hidden on gather all the data and the unhidden on displaying the data. That way the unhidden on can be set up to swap data in the cells? If so I just need to figure out how to code a button, check box or radial to change the information. This may be a more cumbersome solution but it may actually do what I am asking…any thoughts????

[jabryantiii]

how do I get a check box to tell Cell B18 on the sheet to look at Cell B18 on another sheet if checked or if unchecked to look at Cell S18 of the other sheet?

or even on the same sheet? I would like to be able to use a check box for this action, unless there is a better solution that someone can enlighten me on.

[rylo]

Hi

If the check box is linked to cell A18, then you could do

=IF(A18,Sheet2!B18,Sheet2!S18)/.

For the first 2 posts, I'm not sure I follow. Can you please attach an example spreadsheet, showing what you would expect to show where for a given set of criteria.

rylo

[jabryantiii]

Rylo,
Is it possible to do that for a range of cells? What I would like to do is swap that linking in a range of cells from one link to another. So if cells B4:B9are linked to D4:D9, I would like a way to swap to E4:E9 as the link and back again.

[jabryantiii]

included is the attachment

[rylo]

Hi

Do you want the entire range to be actioned by one check box, or do you want to have a check box for each individual cell? Either way, you will still be using the IF logic from above, but you will either have it for each item, or have it referenced back to the linked cell for the single item.

rylo

[jabryantiii]

I am looking to have the whole range action’d by a button, check box or radial.

To give you some background, the purpose for this is to hide or display information depending on the situation at the time. When one of the sale people uses the workbook I created to write bid up they will eventually print the bid for the customer. To prevent a competitor from being able to see specific part numbers I had to write generic descriptors. Those descriptors are what I am looking to swap out with the actual part number. This way the sales person can display the actual part number for the customer at the time of the bid but when they print they are printing out the generic descriptors in the bid sheet.

[rylo]

Hi

How does this go.

rylo

[jabryantiii]

took me a second or two to realize there was a link in the check box to cell A1, once i saw that i realized what you did, and what i blindly missed. Thats for the assist.