Move column values w/o formula
Here is a layout of what I am dealing with:
A B C D E 1 a b c d e 2 2 4 6 8 10 3 2 4 6 8 10 4 4 8 12 16 20 5 1 1 6 8 10 6 1 1 6 8 10 Row 1 is a fix row and row 4 is the total for the column. Row 5 & 6 is data from external source (ACCESS). Column a & b are values and c,d,&e are values taken from c5, d5, etc. I need a way to move columns forward w/o loosing the formulas. For example, delete a2 & a3 and copy and paste b2 &3, c2 & 3, d2 &3, and e2 &3 one space to the left but keep all the formulas in tack. Any advice would be appreaciated. Thanks, Greg |
Did anyone get back with you on this?
I need help, actually doing something similar but different, of course. I need to know how to copy numerous columns so I can paste them at the end, but I want the formula in each cell for each subsequent column (in one row) to just go up by 1. For example if a cell's formula is C1+1, then the next cell is C1+2, then the next cell is C1+3... How do I get that to continue when I paste in the columns containing the C1+1, the C1+2, and the C1+3 cells in a row?... +4, +5, and so on? It's gotta be so simple that I just can't figure it out. "Greg" wrote: Here is a layout of what I am dealing with: A B C D E 1 a b c d e 2 2 4 6 8 10 3 2 4 6 8 10 4 4 8 12 16 20 5 1 1 6 8 10 6 1 1 6 8 10 Row 1 is a fix row and row 4 is the total for the column. Row 5 & 6 is data from external source (ACCESS). Column a & b are values and c,d,&e are values taken from c5, d5, etc. I need a way to move columns forward w/o loosing the formulas. For example, delete a2 & a3 and copy and paste b2 &3, c2 & 3, d2 &3, and e2 &3 one space to the left but keep all the formulas in tack. Any advice would be appreaciated. Thanks, Greg |
All times are GMT +1. The time now is 08:40 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com