Hello!
I am new in the VBA so I would like to ask a little help.
I need to find a value in a sheet (second sheet in the workbook) (it's the header cell of a column) this column's position always different, so it can be in C or D or E etc. column).
If i can find it, i need to jump into last cell (what contains value) in this column (luckily it doesnt have empty cells between datas), go up with one cell and after step into left way with 8 cell and i need that value in a different sheet.
For example: Header cell in N2, so it will jump into N17, go back with 1 cell N16, go into left way with 8 cell so i will get the F16, and i need this value.
Just the column's number and row always depend on header's location.
I am new in the VBA so I would like to ask a little help.
I need to find a value in a sheet (second sheet in the workbook) (it's the header cell of a column) this column's position always different, so it can be in C or D or E etc. column).
If i can find it, i need to jump into last cell (what contains value) in this column (luckily it doesnt have empty cells between datas), go up with one cell and after step into left way with 8 cell and i need that value in a different sheet.
For example: Header cell in N2, so it will jump into N17, go back with 1 cell N16, go into left way with 8 cell so i will get the F16, and i need this value.
Just the column's number and row always depend on header's location.