Hi,
I have a workbook with 3 sheets:
- Lista - a sheet with the list of names in column A and with a button ("Wypełnij_zbiorówkę" macro assigned to the button)
- Szablon (hidden) - a template used by "UtworzSzablon2" macro
- Zbiorówka - the master sheet; data from "Szablon" are put there after running "Wprowadź_klinięcie2" macro
I would like "Wypełnij_zbiorówkę" macro to start with Lista!A1 and move down the list as long as there are values (names). I also need those values (names) to be put in Szablon!C2 cell.
This is what I got so far:
Code
Sub Wypełnij_zbiorówkę()
Call UtworzSzablon2
Call Wprowadź_Kliknięcie2
End Sub
Sub UtworzSzablon2()
'2018-01-21
Application.ScreenUpdating = False
If Not Sheets("Szablon").Visible Then Sheets("Szablon").Visible = True
Sheets("Szablon").Select
Sheets("Szablon").Copy After:=Sheets(2)
ActiveSheet.Name = "Nowy"
Sheets("Szablon").Visible = False
Range("C2").Select
ActiveCell.Value = "=Lista!A1"
End Sub
Sub Wprowadź_Kliknięcie2()
(here is the rest of the macro but it is not necessary to put all of it)
End Sub
Display More
The code works but only for Lista!A1 cell. I have no idea how to make this macro move down to A2, A3 and so on.
Any ideas, anyone? Please help