Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Changing structure of table in the code of macro - insert rows
Hello, I've attached file 1: 5 variable which adding new year between the same numbers of empty rows Now I would like chcnage sturture for table (file 2: 5 variable change structure) various empty rows between variables X Y Z G H. I don't know how to modify this macro. Thank u for help. file...- jpol
- Thread
- Replies: 15
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Using head in VBA
Hello, I would like to automating some operation with macro, and here is a problem with the head. At the beginning I’ve attached files that are done as a model - to represent how the macro works. 1) 5 variable with limit or second file 2) variable_s_f - a slightly different approach to the...- jpol
- Thread
- Replies: 1
- Forum: Microsoft: Office
-
How to do an automation for copy paste, added new row (macro)
Hello I have attached file I want to automated a some step (tab table Z) Thus, for example, that in X 2012: 1) I want to copy D16:E16 2) added a new one blank below before the paste D17:E17 3) converted the 2011 to 2012 in cells D17: E17 (ctr+h function find 2011 replace the 2012) and by...- jpol
- Thread
- Replies: 8
- Forum: Microsoft: Office
