First off, let me start by saying that I barely know anything about SharePoint. I already posted my question on the Excel forum and I got a hint that SharePoint might help me out with the issue.
In Excel, there is a well-known option called "fill down formulas in columns adjacent to data" but I want to "fill down VALUES in columns adjacent to data". Do you have any ideas on how to accomplish this?
I have an External Data table linked to a SQL Server query. I want to be able to put some notes in the right column adjacent to linked data. As rows are being added or removed from the linked data, my notes are getting out of sync with the original row number.
Is there a way of tricking Excel/SharePoint in keeping those columns synced?
My linked table does not have a Unique Column or Primary Key.
I was hoping SharePoint might have some extra trick. I do not know how a custom UDF might help in this case because rows are not unique. If I had a unique column or combination of columns I would be able to provide a row number at the source (SQL Server
in this case).
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.