Share
Report
207Hi All ,
I have a scenario like to update only 3 columns (more than 10 columns available in my SharePoint list) from the source file which is placing under some SharePoint library .
Upstream team will create one excel file with 3 columns. This excel file values changes every month (once a month) and copied into common share point library location . What I need is the accounts in share point should get updated from the value in the excel for each account automatically
SharePoint list templates:
The excel will have 4 columns including Account names:
Account Name | YTD Revenue | YTD Margin | FY Forecast |
Abc |
|
|
|
Xyz |
|
|
|
|
|
|
|
These 4 columns are already there in SharePoint list , the values should get updated on the respective account names in the list.
Is it possible?
Please help me to complete this task asap ..
Thanks & BR
DK
All responses (
Answers (
