Forum Discussion
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
- NikolinoDEPlatinum Contributor
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.