Re: Need to switch 2 columns with each other...please help

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



>I have a spread*** that I started and someone else finished. It performs
>calculations and works fabulously.

I can vouch for that! <g>

Biff

"Buckwheat" <Buckwheat@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3F3EC6C6-3148-46C8-A897-C9F9EB49A734@xxxxxxxxxxxxxxxx
>I have a spread*** that I started and someone else finished. It performs
> calculations and works fabulously, but, on my spread*** my first column
> (column A) is my "Sold" price and in column B, the "cost" price. I need
> to
> switch columns and make column A the "Cost" column and column B the "Sold"
> column. The columns are formatted somehow down to line 100 with its
> "function" jobs to where all I have to do is put in the sold and cost
> prices
> and it will calculate how much the salespeople made, the manager made, the
> buyer and the senior buyer also made. How can I switch the columns and
> still
> get all my columns to calculate properly. Thanks very much in advance for
> any and all help.


.


Quantcast