Let's see I have a few cells which have cell references. So for example A1:A4 have the values K10, B3, X20, B6
<tbody>
K10
B3
X20
A6
</tbody>
Is there a way I can get the values at those cell references and put them in the corresponding cells in col B?
I have a list of data in column x in sheet1 data starts in X1 and goes down to x20
what I need is 1 by 1 search the values in X1 to x20 and try to find that value in the 1st column of every sheet and delete that value. If it can't find it don't do anything and if a cell in X1 to x20 is blank...
Hi,
Just a quick bit of advice before I look into continuing.
Imagine a range which is say A20:X23 & there is a code in each cell that is incremated by 1 each time as you go down the page.
Let’s say the last row with cell values is X20 X21 X22 X23
If a value was entered into cell Y20 can...
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.