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
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