Need help writing a VBA Code

Status
Not open for further replies.

Meko1

New Member
Joined
Oct 20, 2020
Messages
44
Office Version
  1. 2016
Platform
  1. Windows
Hello, since I am quite new to the VBA coding I would appreciate if one of the excel gurus could help me out.

So I want to create a button which on click will run the following:
I want it to copy-paste the data from sheet "student 1" to sheet "contract 20" and afterwards to print it. For example from B5-->to B3, C3 as you can see from the images.
At the same time I need to consider that I have few hundreds of student sheets like "student 1", "student 2"... and all the information is inside in yellow color is entered by hand.
So macro needs to understand the sheet I am standing at and from that sheet copy-paste data to the contract and afterwards to print it.
Another issue with the contract is that as you may see it is written as a text, using Concatenate or just "" and the data I am filling from the student sheets in some cells it comes after the text.

P.S. as you may see contract is in 2 language my mother tongue and English and in student sheets the data is entered similarly but if you can help me out just doing it on English it would be awesome.

I would be very grateful if this can be done.
Thank you in advance.

Screenshot 2020-11-03 001413.png
Screenshot 2020-11-03 001333.png
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
50,750
Office Version
  1. 365
Platform
  1. Windows
Duplicate Need VBA coding assistance

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).
 
Status
Not open for further replies.

Watch MrExcel Video

Forum statistics

Threads
1,118,523
Messages
5,572,639
Members
412,478
Latest member
MakeItWorkVBA
Top