Hi,
I have a macro that copy-pastes raw data from a worksheet. Say Columns E-I are those that are copy and pasted as values. The problem is A-D and J-M are formula driven. And the number of rows from Column E-I will vary depending on number of trades that day. How can I automate the copying of formulas of A-D, and J-M pasting it to the last line populated in E-I through a macro code?
Bookmarks