Hi there, if it is a formula it is a little more tricky but still possible, if it is purely information it is relatively easy and if it database related I am not experienced in it myself so do not know how my advice would impact you, sorry.

Before you start, I would "save as" spreadsheet A n B as another name so you keep your original and can modify the second keeping the stress levels down if things go pear shaped.

To transfer the information to spreadsheet A n B, prepare the column that want to dump it into if it is in-between. Then go to spreadsheet B n C and simply select all the cells you want to copy over and hit copy. Go back to spreadsheet A n B and select the top left cell to paste your column C info in and it will dump the info in. Remember you may have some variables in spacing so some copy and pasting may be needed.

If there are formulas I have just re-written the first line and then copied to all lines below.

Hope that helps or even on the right track.

PM me if you like me to have a look if the info is not to case sensitive. Or post a few screen shots of a dummie scanario to show what you are trying to do.