Cut and Paste Options?

Is it always the same row(s) or will they vary each time?

You'll need to have a macro to do that. I set up a macro (see attached) with the shortcut CNTRL + SHIFT + V which you'd need to call (through that shortcut) where you've selected the row you want to paste into but before you paste.

The macro pastes the row, returns to the original sheet (in this case "Inventory") and deletes the original row.. Try it with my example. Is that what you want?

ChemistB

Originally Posted by howardjo

Is it always the same row(s) or will they vary each time?

They will vary in content--it's two inventory sheets I work with. I would love to find a way to keep the formulas on the receiving page's column "fixed" when I paste the incoming row on that page. As it is, the row I paste brings with it it's formula.

Originally Posted by ChemistB

You'll need to have a macro to do that. I set up a macro (see attached) with the shortcut CNTRL + SHIFT + V which you'd need to call (through that shortcut) where you've selected the row you want to paste into but before you paste.

The macro pastes the row, returns to the original sheet (in this case "Inventory") and deletes the original row.. Try it with my example. Is that what you want?

ChemistB

Yes, that works perfect in your example. Do I need to create a macro for my file, or is it possible to use this one? Again, newbie!

Also, as I asked as a follow-up question, is there a way to "force" the rows being pasted on a sheet to take on the formula that is already there? In your example it would be as if the "Sheet 1" column J, for example, had a formula running down its length to give total sales down lower. What I'd like to happen is as I add rows from the "Inventory sheet", that row would take on the formula when it's pasted in place. As it is, the rows bring in their own formulas, or leave the cell blank.

Any ideas?

BTW, thanks for the help so far. I think I'm on to something.

In order to have it paste values only, first, you need to use Copy instead of Cut and then substitute

Please Login or Register  to view this content.

in my macro with

Please Login or Register  to view this content.

If you follow the directions in my post, it doesn't matter what row you are pasting from or to. It will paste the values into the row you selected and then go back and delete the original row.

ChemistB

Yes, that works perfect in your example. Do I need to create a macro for my file, or is it possible to use this one? Again, newbie!

Also, as I asked as a follow-up question, is there a way to "force" the rows being pasted on a sheet to take on the formula that is already there? In your example it would be as if the "Sheet 1" column J, for example, had a formula running down its length to give total sales down lower. What I'd like to happen is as I add rows from the "Inventory sheet", that row would take on the formula when it's pasted in place. As it is, the rows bring in their own formulas, or leave the cell blank.

You can copy my macro over to your workbook (Alt F11 to access the macro editor, then find the macro in Module 1 and insert a module into your workbook and paste it..

If I understand you correctly, on the sheet you want to paste to, you already have formulas that you don't want to overwrite? That will be more complicated. You are, by definition, pasting over what was already there. Maybe I can help if you post an example of how your workbook is set up.

ChemistB