Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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