New posts

Reply to thread

Message

Thanks for the offer. I timed the process today.

(1) Manually input prices into the spreadsheet: 67 min

(2) Sort order by cut & pasting: 25 min

All up : about 1.5hr.

re #1: I could create a macro to download the data from the CY22 watchlist into the spreadsheet. However the way I've set up the spreadsheet it gets awkward when the next months data is input. It replaces the prior months data and I want to keep it all. It could be done but I'm not certain it would work out so easily each month.

The main xls looks like this;

[ATTACH=full]136806[/ATTACH]

I suppose I could get the prices from the watchlist and transfer them into the monthly column based on the stockcode in column B.
Any suggestions would be welcome if it saves 30min. If you prefer to PM me please do.

re #2 Tricky for me to create a macro to sort every fifth line (by totals) without getting the other lines out of order. This becomes less work as the year progresses as the order gets more established.

<blockquote data-quote="peter2" data-source="post: 1158548" data-attributes="member: 13908">Thanks for the offer. I timed the process today. (1) Manually input prices into the spreadsheet:&nbsp; 67 min(2) Sort order by cut &amp; pasting: 25 min&nbsp; All up : about 1.5hr.re #1: I could create a macro to download the data from the CY22 watchlist into the spreadsheet. However the way I&#039;ve set up the spreadsheet it gets awkward when the next months data is input. It replaces the prior months data and I want to keep it all. It could be done but I&#039;m not certain it would work out so easily each month. The main xls looks like this; [ATTACH=full]136806[/ATTACH]I suppose I could get the prices from the watchlist and transfer them into the monthly column based on the stockcode in column B.Any suggestions would be welcome if it saves 30min. If you prefer to PM me please do. re #2 Tricky for me to create a macro to sort every fifth line (by totals) without getting the other lines out of order. This becomes less work as the year progresses as the order gets more established.</blockquote>

[QUOTE="peter2, post: 1158548, member: 13908"] [B]Thanks for the offer[/B]. I timed the process today. (1) Manually input prices into the spreadsheet: 67 min (2) Sort order by cut & pasting: 25 min All up : about 1.5hr. re #1: I could create a macro to download the data from the CY22 watchlist into the spreadsheet. However the way I've set up the spreadsheet it gets awkward when the next months data is input. It replaces the prior months data and I want to keep it all. It could be done but I'm not certain it would work out so easily each month. The main xls looks like this; [ATTACH type="full"]136806[/ATTACH] I suppose I could get the prices from the watchlist and transfer them into the monthly column based on the stockcode in column B. Any suggestions would be welcome if it saves 30min. If you prefer to PM me please do. re #2 Tricky for me to create a macro to sort every fifth line (by totals) without getting the other lines out of order. This becomes less work as the year progresses as the order gets more established. [/QUOTE]

Verification