Hi,

Why do you need a macro for that?  If you can explain in detail what you need and provide a workbook with an example of what you want to happen then it will be clearer and easier to provide an answer.

To elaborate - when you say 'certain cells' do you mean adjacent cells, non-adjacent cells, a row, a column???

Regards

Phil

Hello Phil,

I'm sorry i am very new at this. I have uploaded a test file.

For each product that i have listed, there is a line of Current Pricing and a line of Last Pricing, when the buyer is finished with the Current Pricing (which includes Last, Average, COG On Order, Market Price, and Warehouse Price) they would like to send those prices down to the Last Line.

I was hoping to create a macro with a button so the buyer could just select the cells of a product and click the button and that would send the costs down.

I hope this makes a little sense and thanks for your help.

Brant

Hi Brant

You can give this a try.

Just select any SKU and click the Move Down button.

I assume that you want to move the entire selected row to the bottom of the data (instead of one row down??) since you did not give a sample of your expected result.

Good luck.

Sunny

Hi Sunny,

Thank you so much for trying, but that is not really what i am after. I see with my poorly labeled data how you took my question.

Let me try this again.

My buyer for instance will look at 1 sku, let's say 00651, he will fill in the pricing for I3, J3, K3, N3, and O3 and when he is done with his process he wants to click a button to move those costs down to I4, J4, K4, N4, and O4.

When i said current pricing and last pricing in a previous post i was referring to the H column and thus the prices in their respective rows.

Now i will not know which sku's he will be changing and thus i need the macro to be based off the buyer's cell selection.

With all this said, i believe i have it working.

I had trouble attaching a file, but anyhow i do have it working.

Thanks!

Brant

Hi Brant

Glad you got it sorted out.

Just curious to know why you move the newly entered Current cost in row 3 down to the Last cost in row 4.

I would assume that the Current cost should have been moved down BEFORE you enter the new Current cost.

Otherwise both Current and Last cost would be the same.

Am I missing some thing?

Sunny

Hi Sunny,

When our buyers are looking for lumber, they are plugging in the current market costs of the lumber and when they decide to buy then we move the data down to the last line for that sku and start again and this is a tool to help us to decide if we have to raise or lower our sell prices.

Thanks Again.

Brant