How to use if and loop functions

Hi all, I have few questions, sorry I'm a Newbie to Macro.

I attached a sample of the file I am working on.
BOOK1.xlsx
What I am trying to do is to build a macro the will do the following:
--Go to sheet Input , then copy A2:D2
--Go to sheet Calculation and paste it in the second line A2:D2
If D2=12 then copy A4:D15
If D2=11 then copy A4:D14
If D2=10 then copy A4:D13
and so on until D2=1 then copy A4:D4
--Go to sheet Output and paste in the first empty line
then loop again to take next line in the Input Sheet.
Is that easy ?

Hi, gogz2005,

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Ciao,
Holger

Hi, gogz2005,

maybe use a code like this:

Please Login or Register  to view this content.

CIao,
Holger

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Did you know that to say thank you, click on the star at the bottom of the post for the person who helped you? (Add Reputation)