View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.setup
chelseafc19692006andon
 
Posts: n/a
Default copy a function to a whole column

I am entering a figure in column A, i want column B to automatically work out
the vat element of the figure in column A. Then i want column c to add the 2
figures together and display the answer. No problem i can write the formulae
but i want it to apply to every row on the worksheet (and there could be
thousands) and do not want to write it for every one. Ive tried to copy and
paste but it doesnt seem to work, please please please can any one shed some
light on this for me .... thanks