Automatically copying data/cell

Resolved · Low Priority · Version 2007

Wed 28 Aug 2013, 10:24 Delegate Lisa said...

Lisa has attended:
Excel Introduction course

Automatically copying data/cell

Hi,
I was wondering if there is anyway I can have excel automatically copy the information in one cell to the next cell to its right.
I have a spreadsheet where I key in sales and profit figures which show the total for each sales person at the end of their section, so I want this total to hop to the cell to the right so all the totals will be in one column and add up at the bottom. E.G. the total has a formula =SUM(C7:C30) when I copy and paste it to the cell to the right it just shows £0.00 as it is taking the formula and it becomes =SUM(D7:D30) so total is nil. Is there a way I can make the cell to the right take the information from the cell to the left and automatically update the information as I key more sales/profit figures? I hope this makes sense.
Many thanks,
Lisa

Wed 28 Aug 2013, 11:35 Trainer Andrew said...

RE: Automatically copying data/cell

Hi Lisa

Thank you for your question. One way may be to just use equals and point the formula at the cell containing the total you need.

For example if the total you wanted to duplicate is in C31 then in D31 you could enter the formula =C31

This would copy the value from the neighbouring cell and it would also update as you changed the values in column C.

Do you think this might work for your data? If not let me know and I can look at alternatives for you.

Kind regards,
Andrew

Wed 28 Aug 2013, 13:03 Delegate Lisa said...

RE: Automatically copying data/cell

Hi Andrew,
That looks like it will work a treat - Thank You!!
Lisa

Wed 28 Aug 2013, 14:06 Trainer Andrew said...

RE: Automatically copying data/cell

Hi Lisa

I'm glad to hear that thank you for letting me know. Do get in touch if you have any further questions.

Kind regards,
Andrew

Wed 4 Sep 2013: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Autofit column width – Excel (all versions)

a. Highlight the column or columns you wish to alter the width of. You do this by clicking on the grey button at the top of the column showing the column letter. Click and drag on these letters to select more than one column.
b. Double click the dividing line between the columns. This dividing line is the break between the columns on the column headers (grey buttons showing the column letter at the top of each column). When you hover your mouse over one of these dividing lines the point will change and show an arrow pulling a line in two directions. When you have this mouse pointer you should double click to get Excel to automatically set the column width to fit the contents of the column (autofit)

View all Excel hints and tips