Skip to Content
0
Former Member
May 05, 2009 at 11:48 AM

Problem in Workbook

21 Views

Hi all,

I have the following scenario in my worksheet.

Row1

Row2

Row3

Total1

Row4

Row5

.

.

.

Rown

Total2

Total3=Total1+Total2.

The thing here is that Row1,Row2 and Row3 come from one query and Row4, Row5,...Rown come from another query ,Also, the number of rows in the second query are based on a condition , so there is a possibility where in i can get no results based on the condition as well..

My question is, is there any possibility to shift the total3 row dynamically upwards or downwards based on the number of rows in query2 ?? Please let me know if there is any option in excel or any script for the same.

Thanks and Regards

snehith.