Forum Discussion
copy data
hello i want to copy cell contents from cell above by just typing the first letter or so of the cell above. this seems to work when the vacant cell is directly below but not always when it is a few ...
thanks, your system worked, however when i went to copy into another doc it showed as a box rather than just a line of text so not ideal. but i have been talking to other staff here and am trying another system using if statement and then concatenate
thank you
If you paste values there should be no box