Forum Discussion

Tjommien's avatar
Tjommien
Copper Contributor
Sep 30, 2020

Macro: Copy formulas from one sheet and paste it into another sheet in the same workbook

Hello! I hope you can help me making a macro to do this:

 

Copy two formulas in a Workbook from Sheet1 to Sheet2 in B2 and B3.

Then autofill column B and C to the last row in database

 

The database in Sheet2 is as follows:

 

COLUMN a    COLUMN b         COLUMN c

prefilled             macro                macro

CLASS              LEVEL                PROGRAM prefilled

1: 1HTA                1HT                   HT

2: 1RMA               1RM                  RM

3: 1RMB                1RM                 RM

4: 2RMKOSA         2RM                 RM

5: 2RMMFGA         2RM                RM

6: 1STA                  1ST                  ST

7: 2STB                   2ST                 ST

8: 3STC                   3ST                 ST

 

This is the formulas i want to copy using a macro from Sheet1!B1 and Sheet1!C2

a) =LEFT(A2;3)

b) =RIGHT(B2;2)

 

I have tried different options but i haven't found something that works

 

I hoppe you have a solution to this challenge

1 Reply

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor

    Tjommien 

     

    Here is a small template for your project, you can adapt it as it suits you.

     

     

     

    I would be happy to know if I could help.

     

    Nikolino

    I know I don't know anything (Socrates)

     

    * Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

Resources