Dear Roger,
Thank You for Your advice,
I am Sorry for not making myself understood here, my apologies for the
misunderstanding. My question is part of whet I need to include in a Macro.
The Macro creates the Pivot-Table, then Copies the pivot table and pastes
Values so that I can then work with the data retrieved from a Database, and
The data that I need to calculate is and can not be retrieved in this
pivot-table.
The problem here is that I need to make calculations using data in one row
and comparing it against the next non-blank cell in a column....
Still doesn't make it any easier I presume, sorry, and Many Thanks for Your
attention again!
Hilvert
"Roger Govier" wrote:
Hi Hilvert
You need to use the GetPivotData function.
For help on this take a look at
http://www.contextures.com/xlPivot06.html
--
Regards
Roger Govier
"Hilvert Scheper" wrote in
message ...
Hi there Dear specialists,
Can I Please have some help with this;
I want a Formula that finds and returns the Text-string from the next
Non-Blank Cell in the previous column. The reason why I'm asking is that
this is part of a Pivot-Table, due to which some cells are empty and the number of empty cells is Variable.
Many Thanks for Your help, I hope this example helps:
Column A Column B
(blank) In Cell B1 I need to find the next non-blank cell in
(blank) column A, and return text-string "SN2 2QH" from
Cell A4
(blank)
SN2 2QH
Thank You again,
Hilvert