Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
poppy wrote ...
I want to be able to find the last empty row in a worksheet and work out the totals of each column and place it in this row. As you used SQL to fetch the data, I can tell you can use a query to insert the total in Excel e.g. INSERT INTO [MySheet$B3:B65536] (Price) SELECT SUM(Price) AS Price FROM [MySheet$B3:B65536] ; Although in the above the maximum rows has been specified, in reality the provider will find the next unused row and insert the total there. However, a SQL insert can only be done on a closed workbook. Is this a show-stopper for you? For your original question about formatting, your sample data is all over the place as I see it: http://groups.google.com/groups?selm...rum-nospam.com You may want to repost. Jamie. -- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Finding the next empty cell. | Excel Programming | |||
Finding last non-empty column in row... | Excel Programming | |||
Dynamically finding the last empty row | Excel Programming | |||
Finding Empty Rows | Excel Programming | |||
Finding Empty Rows | Excel Programming |