Hi everyone, first post here. I'm new to macros in Excel but I've done some VB coding so they make some sense to me.
Here's my situation: I have an Excel sheet that is linked to a SharePoint list. (I'm using Office 2007 and had to download the Synchronize Excel and SharePoint add-in to do this.) I would like to have it so that when a user enters new information (adds a new item/row) on the SharePoint list, the Excel workbook adds this row and keeps the formulas that are in the rows above. I've found some code that will keep the formulas in the above row when a new row is manually added, but I'd like that to happen automatically when a user new information in the form of a row/item.
Any help would be awesome, thanks!
Here's my situation: I have an Excel sheet that is linked to a SharePoint list. (I'm using Office 2007 and had to download the Synchronize Excel and SharePoint add-in to do this.) I would like to have it so that when a user enters new information (adds a new item/row) on the SharePoint list, the Excel workbook adds this row and keeps the formulas that are in the rows above. I've found some code that will keep the formulas in the above row when a new row is manually added, but I'd like that to happen automatically when a user new information in the form of a row/item.
Any help would be awesome, thanks!
