Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Need to switch 2 columns with each other...please help
I have a spreadsheet that I started and someone else finished. It performs
calculations and works fabulously, but, on my spreadsheet 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. |
#2
|
|||
|
|||
Select the column header of B by right clicking it,
select cut, select column A, right click and select insert cut cells -- Regards, Peo Sjoblom "Buckwheat" wrote in message ... I have a spreadsheet that I started and someone else finished. It performs calculations and works fabulously, but, on my spreadsheet 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. |
#3
|
|||
|
|||
I have a spreadsheet that I started and someone else finished. It performs
calculations and works fabulously. I can vouch for that! <g Biff "Buckwheat" wrote in message ... I have a spreadsheet that I started and someone else finished. It performs calculations and works fabulously, but, on my spreadsheet 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Clearing information in certain columns | Excel Discussion (Misc queries) | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
Switch Rows and Columns | Excel Discussion (Misc queries) | |||
print excel columns on less pages | Excel Discussion (Misc queries) | |||
Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) |