Copying a call contents from the left to the right

  • Thread starter Thread starter Larry
  • Start date Start date
L

Larry

How would I within the same row for a every other column
have a funtion (formula) copy the contents of some cell to
the left in the same row based on one column that contains
the number of columns to move left. This value will be put
in by the user and will dictate how many columns to go
left and the value will not be the same for every row.
This value can be changed by the user realtime and the
spreadsheet needs to reflect the change for all columns
that conain the formulas. I will always have the value to
move left in the same column for every row.

Thanks,
Larry
 
Hi Larry
not quite sure what you're tying to achieve. Maybe you can give an
example.

Maybe the function OFFSET is what you're looking for
 
Frank,

I tried Offset and it works. Maybe you have a better way.

Example of what I tried to do. It is a source of income
chart. The week of a billing vs. receipt based on leadtime
to get paid. The "B" is the billing dollars and the R is
the week of receipt of those dollars. The #weeks is the
expected weeks to received the check from the customer.

Weeks 3/21 3/28 4/4 4/11
B R B R B R B R
#Weeks
Job #

1560 2 10 10
1561 3 16 16
1562 1 6 5 6 5

Total 6 10 16
 
Back
Top