1. Games
  2. Login
  3. Register
  4. Support
  5. 00:05:07
  6. en

moonID.net - Please discuss stuff about moonID hereBug reports → Macro with IF function copying and transferring formats

MichaelSmith
avatar
Posted May 9, 2018, 4:40 p.m.
Edited by MichaelSmith May 9, 2018, 4:40 p.m.
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" .

Please help.

I didn't find the right solution from the Internet.

References:-
https://forum.openoffice.org/en/forum/viewtopic.php?f=45&t=91195
<a href=https://jobs.vidzzy.com/hire-creative-video-marketing-studio/>Creative marketing studio</a>

Thanks
Page:  1
You need to login to add a post.

Connecting... Connecting