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!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jpol
  • Order by date
  1. jpol

    Changing structure of table in the code of macro - insert rows

    I mark it on last post in test workbook. For example X-152 etc. for 2010 it is -153 etc. date-154 etc. It's mean a number of columns and rows. No condition is for name. Unfortunately I don't decide about conditions. If I could decide about it I would leave the old version tab Z. I don't want to...
  2. jpol

    Changing structure of table in the code of macro - insert rows

    What is wrong? What part of my answer you don't understand?
  3. jpol

    Changing structure of table in the code of macro - insert rows

    .........A by analogy B after changes table: A by analogy B X-152 2010-154 X-152 2010-154 2011-164 2011-164 2012-174 2012-174 2013-184...
  4. jpol

    Changing structure of table in the code of macro - insert rows

    .........A by analogy B after changes table: A by analogy B X 2010-154 X 2010-154 2011-164 2011-164 2012-174 2012-174 2013-184...
  5. jpol

    Changing structure of table in the code of macro - insert rows

    In sheets 2010, 2011, 2012, I have source of date which structure is always constant. In table Z I have got raport: X 2010 2011 2012 Y 2010 2011 2012 Z 2010 etc. So if I add sheet 2013 (where I have date XYZ) etc. after use...
  6. jpol

    Changing structure of table in the code of macro - insert rows

    Sub aaa() Dim Wks As Worksheet Dim i As Integer With ThisWorkbook.Worksheets("table Z") Dim OstW As Long: OstW = .Cells(Rows.Count, 4).End(xlUp).Row If OstW > 14 Then .Range("B14:E" & OstW).ClearContents End If .Range("D14:E14").Value = Array("A", "B") .Range("B15:B19").Value =...
  7. jpol

    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...
  8. jpol

    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...
  9. jpol

    How to do an automation for copy paste, added new row (macro)

    Thank u very much for query method. I've been demonstrating VBA just for added value to this thread.
  10. jpol

    How to do an automation for copy paste, added new row (macro)

    Thank u for help. I am testing this one later because here I have only Excel 2000. Suppose that in the Excel 2010 a Structured Tables is availables also? I've got some macro code. But there is some problems 1) with loop macro: I use macro only for sheet: table Z. When I start macro then added...
  11. jpol

    How to do an automation for copy paste, added new row (macro)

    Sorry for cross-posted. I've sent in this way because I've not got any responds. So it isn't idea: If you post on several boards, you have several groups of people working on the same issue, without necessarily knowing what the others are doing. Perhaps badly presented to the Board. By the way...
  12. jpol

    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...

Part and Inventory Search

Back
Top