Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sharepoint List to Excel with Totals
I have an Excel workbook that connects to a list on a Sharepoint site and
updates dynamically. I need to write an auto_open macro that puts a couple of formulas in the cell directly under the list that continues to update, to sum or average the list of data. I tried using the offset command to get the cell under the data area, and that worked my problem is telling the formula what to Sum or Average as the range gets wiped out when I select the cell under the data area. I hope that all makes sense, any help as always is greatly appreciated. -- <<Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't Synchronize Excel List with Sharepoint | Excel Discussion (Misc queries) | |||
Can't group a Sharepoint List in Excel by Created date | Excel Discussion (Misc queries) | |||
How can I Export a SharePoint list to a spreadsheet in Excel 2002 | Excel Discussion (Misc queries) | |||
Can't publish Excel list to Sharepoint | Excel Discussion (Misc queries) | |||
Subtotals in Excel 2003 for doc exported from Sharepoint list | Excel Discussion (Misc queries) |