Excel / Sharepoint knowledge (99% excel)

Closed Posted Jul 17, 2014 Paid on delivery
Closed Paid on delivery

I need help with a project i am trying to do. I created a SharePoint site, and exported the data into an excel spreadsheet. I now use the connection feature in excel to update/pull the new data. Here is my issue:

I need a way to copy & add the data that is pulled to a new Tab in excel. It doesn't duplicate the data that is the same, and adds any new updates.

Sharepoint tidbit: Sharepoint is live, so if something is deleted because we dont need it anymore, it disappears when we update in the excel, however we dont need it on sharepoint we do need to capture the data it had before it was deleted.

Hopefully this is clear.

Any questions please feel free to ask, also do not accept unless you completely understand what i need. Dont waste each others time, also post "K" in your bid, i dont like auto responses.

See example!

Thank you

Data Entry Data Processing Excel Sharepoint

Project ID: #6203496

About the project

11 proposals Remote project Active Aug 23, 2014

11 freelancers are bidding on average $25 for this job

sonarkaushik

Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have done lots of these kind of projects and will deliver flawless work Looking for further discussions in this reg More

$29 USD in 3 days
(84 Reviews)
6.1
gish2014

K. Hi there. I'm programming in VBA. Question is: can we use specific tab (sheet1 for the matter) to be used as "entry" gate for new imported dataset?

$25 USD in 1 day
(2 Reviews)
1.4
SAYA10feb

Hi, I do have knowledge of share point as we use this to upload our current project files I am writing in response to your advertisement. After carefully reviewing the experience requirements of the job descript More

$20 USD in 1 day
(1 Review)
1.5
syncro90

24/7 available. Im Liyana from Malaysia. Im an engineering student. I believe I can do this for you. Please provide more details on this project. Thank you. "K"

$25 USD in 5 days
(1 Review)
0.0
azamsxlnc89

A proposal has not yet been provided

$20 USD in 2 days
(0 Reviews)
0.0
pushar71

HI I have good experience and exposure in Sharepoint and Excel pls connect with me i can do the job immediately. Puneet

$25 USD in 1 day
(1 Review)
0.0
aftabseher

I will try my best to work hard. I will certify you with my abilities and intelligence. I reference will be demand.

$25 USD in 1 day
(0 Reviews)
0.0
siksid

A proposal has not yet been provided

$25 USD in 2 days
(0 Reviews)
0.0
J2eeWSDeveloper

Hi , K I can do this job and done this kind I can share the sample work Thanks, Hi , K I can do this job and done this kind I can share the sample work Thanks,

$30 USD in 1 day
(0 Reviews)
0.0
trajasekhar9

A proposal has not yet been provided

$25 USD in 1 day
(0 Reviews)
0.0