Macro to insert rows conditionally.

[HarryC23]

Hi all,

I'm a bit stuck trying to use a macro for the first time. I've got a dataset of certain trades across different markets and traders, and on different days. The date of the trade is in column A, the contract ID is column D and the trader ID is column J.

Traders do not trade every day. I would like to insert a new row/rows for each date on which traders do not trade between their first and last trade, for each market in which they participate.

Is this possible using macros?

And, if so, then I would like to insert the high and low prices for the market on those dates from a different worksheet into the newly created blank rows. On this second workbook the contract ID is column A, the date is column C, the high price is column F and the low price is column E. I would like the low price to be inserted into column AJ on the original worksheet and the high price into column AK.

This second bit might be a bit trickier. Even if you could only help with the first part it really would be much appreciated.

Thanks,
Harry.


n.b. I've also posted this here: http://www.mrexcel.com/forum/excel-q...itionally.html

[venkat1926]

Had you given a small extract of data it would have been easier to prepare the macro. I have designed a sheet (sheet1) in the workbook attached. This is also copied to sheet3 repeat sheet3 to preserve original data.

Three macros are there 1)test2)undo and 3)removeweedned
First run undo so that you get original data
Then run MACRO test. You need NOT run remove
weekends because this is appended to macro test
Now the dates are in serial order but week ends are removed. You may have to remove holidays also that is extension.

I am attaching the file

[HarryC23]

Thank you so much, that's very kind of you. I can't seem to make it work though. I have attached a sample of the data like you suggested which could perhaps make it clearer what I mean? Sorry for not articulating it well enough originally.

It would also be great to insert blank rows until the last date of market activity (seen on sheet2) after the last trade the trader makes in that market.

Trades also take place on weekends and holidays.

Thank you again venkat.