Worksheet manipulation

[bigchesh]

I am trying to copy data from one sheet to another. I have the formulae worked out to transfer from sheet to sheet BUT now I need to protect that data and move everything down 1 line to be able to complete the task again. Basically it is a PO log to record simple info like dates, suppliers, cost and PO number. I want to record the info as I type rather than having to go into each line individually on the log sheet or even worse write it in the log book we use now.

Any takers ?

Big Chesh

 

[Smitty]

Welcome to the Board!

You can do what you want with a VBA change event or a simple button. Which would you prefer? One's automated, one requires a button push.

What's the last consistent column you enter data in (so that all of the relevant information can be copied)?

Smitty