[h=2][/h]
Hi,
I need a Macro in Excel with IF function. Basically the Macro goes through the first row of WS1. IF there is "Charlie" in A1:A3 (merged cells) the Macro will copy the range F2:H6 from WS2 and paste it below "Charlie" in WS1. IF there is "George" in A1:A3 (merged cells) the Macro will copy the range I2:K6 from WS2 and paste it below "George" in WS1. The Macro will then move to the next position A4:A6 (merged cells) and fills the cells below it based on similar information from WS2, and will continue for "Michael", "James" and ...
The copied cells contain hyperlinks, so I need the formats transferred too.
Please help me with that or guide me if a similar answer exists. Thanks
I need a Macro in Excel with IF function. Basically the Macro goes through the first row of WS1. IF there is "Charlie" in A1:A3 (merged cells) the Macro will copy the range F2:H6 from WS2 and paste it below "Charlie" in WS1. IF there is "George" in A1:A3 (merged cells) the Macro will copy the range I2:K6 from WS2 and paste it below "George" in WS1. The Macro will then move to the next position A4:A6 (merged cells) and fills the cells below it based on similar information from WS2, and will continue for "Michael", "James" and ...
The copied cells contain hyperlinks, so I need the formats transferred too.
Please help me with that or guide me if a similar answer exists. Thanks