PDA

View Full Version : Copy & Paste ranges from multiple worksheets



blackie42
10-07-2007, 04:50 AM
Hi

I have a spreadsheet with approx 20 tabs (funds). There are some hiden columns (reason is how it interacts with main input form - but they are blank).

New entries to each sheet are copied and pasted (and values negated) to a day 2 sheet (same tabs). There is an extra column where a price is input. There is then a formula which calculates the number of units based on value/price. Also if value was already in units a different formula is used to arrive at the ? value (although this probably isn't necessary as its the units column that is used for other outputs).

I want to try an automate this process but don't rrally know where to start.

I think first task is to identify the new entries in each sheet in turn and paste in to other sheet at same time negating all values. Then using a form input the price for that day against the new entries. Then do the calcs on the new entries.

The two worksheets would be in the dame folder.

Any hints tips to get me started would be most appreciated

I have enclosed a mock up

Many thanks in advance.

Jon

blackie42
10-07-2007, 04:51 AM
& the 2nd file

blackie42
10-07-2007, 05:06 AM
sorry didn't mean negating all values - what i meant was change the value from + to - or vice versa depending on what it was to start with.

thanks

blackie42
10-07-2007, 11:57 PM
A big ask I know -but any small snippets of code would be useful