Moving Data into another sheet

craig8125

New Member
Joined
Nov 19, 2009
Messages
26
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".
 

Some videos you may like

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Watch MrExcel Video

Forum statistics

Threads
1,108,701
Messages
5,524,408
Members
409,575
Latest member
navarrov74

This Week's Hot Topics

Top