Hi Everyone
I need a little help, I have a sheet which contains fairly simple data in a Sheet called "Trade Planning", it contains data in columns A:T, each of the rows has a mixture of Manually input data and formula, two of which reference a sheet called "Contract Calcs" for some data needed for the equation.
I want to be able to manually select which rows are transferred to a sheet called "Executed Trades" once I decide to take a particular trade, where the information that has been transferred can be added to as the trade progresses.
When the line is transferred I would like the now blank line in the "Trade Planning" to be deleted. Then new line needs to be added to the next available blank line in the "Executed Trades".
I need a little help, I have a sheet which contains fairly simple data in a Sheet called "Trade Planning", it contains data in columns A:T, each of the rows has a mixture of Manually input data and formula, two of which reference a sheet called "Contract Calcs" for some data needed for the equation.
I want to be able to manually select which rows are transferred to a sheet called "Executed Trades" once I decide to take a particular trade, where the information that has been transferred can be added to as the trade progresses.
When the line is transferred I would like the now blank line in the "Trade Planning" to be deleted. Then new line needs to be added to the next available blank line in the "Executed Trades".
