2. Games
    Featured games
    More games+
  3. Login
    Login

    Reset password

    Facebook login Google login
  4. Register
  5. Support
    Forum more Get in contact with other users and admins
    FAQ more Browse through a list of common questions.
    Ticket system more Ask our support staff for help.
    Rules more All rules concerning the moonID portal and boards can be found here.
  6. 12:04:58
    12:04:58 Server time
    12:04:58 Local time
  7. en
    Change language

moonID.net - Please discuss stuff about moonID here → Bug 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