Завершено

copy/update Data from closed Dynamic Range Excel sheet (updated from SQL) to open workbook

Hello,

I am looking for the experienced Excel/VBA, or C# Developer, who can do following job:

I have a Excel Sheet, where the:

- new Data are loaded from SQL Server

- Existing Data are updated from the same SQL Server

- Existing Data that reached specific Status are deleted

(So the table keep Data for specific time)

From this Excel Sheet (That will be closed) I need to ->

- Copy the New entries that are not listed in open Workbook

- Simultaneously update the existing Data to the status from the closed workbook

- simlutaneously, Existing Data that reached specific Status in closed workbook, and after refreshing disappeared, keep them in open workbook.

Those operations perform any-time after clicking on update button in open Workbook

Квалификация: Excel, Программирование на C#, Обработка данных, Visual Basic

Показать больше excel sheet marketing research survey data entry, data excel sheet macro, convert pdf data excel sheet, excel macro pull data from another workbook, excel vba get cell value from another workbook without opening, can excel pull data from a closed workbook, excel vba copy data from closed workbook without opening, excel vba copy data from one open workbook to another, excel vba copy range from another workbook without opening, excel vba copy data from another workbook without opening, how to copy data from one excel workbook to another using macro, import excel sheet sql data base, getafreelancercom extract data website excel sheet, excel script copy cell data closed file, can copy website data excel sheet, excel copy data closed spreadsheet, copy column data sheet macro excel, copy data website excel sheet, copy cell data othe cells macro excel, copy data web site table excel sheet vb code

О работодателе:
( 4 отзыв(-а, -ов) ) Pilsen, Czech Republic

ID проекта: #23925212

Поручен:

Bsram88

Yes We can do basic CRUD operation from excel to sql server. we can use passthrough query to get link between sql and microsoft product, excel, access, etc. and if you prefer C# or vb.net we can also implement your re Больше

$50 USD за 2 дней(-я)
(4 отзывов(-а))
3.0

22 фрилансеров(-а) в среднем готовы выполнить эту работу за $113

schoudhary1553

Hello, I can help you with your project - copy/update Data from closed Dynamic Range Excel sheet (updated from SQL) to open workbook I have gone through your job posting and become very much interested to work with Больше

$220 USD за 4 дней(-я)
(359 отзывов(-а))
8.0
vsprybhanu

Hi, I can develop an excel vba program to update opened workbook from your source workbook which will be closed. I will give a button to update your opened workbook any time by just clicking a button. I am experience Больше

$140 USD за 3 дней(-я)
(91 отзывов(-а))
5.7
gpnr2017

Hello, Hope you are doing well. I have gone through the project requirement and find my self in good position to complete this project either by excel vba or c# code. Thank you for considering my application. I look Больше

$100 USD за 2 дней(-я)
(18 отзывов(-а))
4.7
eduuardo

Hello.. Your first workbook gets updated from SQL and after it gets some status its old data is replaced with new ones, but you need to keep all the data in second MasterBook, where you want to have all the records + Больше

$50 USD за 1 день
(16 отзывов(-а))
3.8
maguirrer

Hello, I can help you with the project, we can create a button on your worksheet that when you click it, the data will be updated from the closed workbook, but please send me a message with more details and with the fi Больше

$35 USD за 3 дней(-я)
(29 отзывов(-а))
4.0
MonisZafar

Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this through a VBA script. It will be quick and accurate. If interested, we can discuss this further on chat.

$80 USD за 1 день
(12 отзывов(-а))
4.1
chrisklick

Hello I am a skilled it developer. Excel VBA and C# is really easy to me. You can know that through my previous works. I can do it easily. Lets discuss more detail via Chat. Hope to hear from you soon. Best Regards.

$140 USD за 7 дней(-я)
(3 отзывов(-а))
3.4
djlucas1234

Hello, there. Nice to meet you. I think python is suitable for this job. So with lxml, pandas library, will be easy for process excel. Also easy to extend. No problem to build UI also. Let me know how can we process th Больше

$140 USD за 3 дней(-я)
(3 отзывов(-а))
3.1
ibrahim20

Hi, I am a c# developer for past 6 years, Have developed many C# windows and web Application(Asp.net ,MVC, Enity framework). Also have been worked with fortune companies and received appreciation. Have experience in ja Больше

$80 USD за 7 дней(-я)
(8 отзывов(-а))
3.2
mauricioalberin

Hello, I would like to help you with your project, I have a lot of experience in Excel and VBA macros. I have a Master in Applied Computing. I have more than 10 years of experience in programming in several languages Больше

$60 USD за 3 дней(-я)
(9 отзывов(-а))
3.0
mdsajjad876

Hi there I read your project description, I have an experience of develop using C# and VB I also strong knowledge about SQL database and SQL Server. I am very confident fro complete your job very short time as you i Больше

$80 USD за 2 дней(-я)
(12 отзывов(-а))
2.4
Crayon1365

hello i'm a developer with over than 12 years experience, and i have done many project in c#.net, ms excel and databases ⭐please see my portfolios in c#.net and ms excel⭐ i can do your project with all of features that Больше

$100 USD за 7 дней(-я)
(5 отзывов(-а))
2.1
godshubham56

Hello ! Get your websites created unlike others. My 12 years of consistent experience and a passion to observe the project deadline make me an outstanding choice for your project. I am experienced in wordpress, mobile Больше

$155 USD за 8 дней(-я)
(0 отзывов(-а))
0.0
$155 USD за 3 дней(-я)
(0 отзывов(-а))
0.0
Lovelysinghaniya

Need a chance to work with you .Happily done your work on time

$111 USD за 2 дней(-я)
(0 отзывов(-а))
0.0
Sohanra

I can assure you quality [login to view URL] i hope you would to discuss about the work [login to view URL] Rahman

$140 USD за 7 дней(-я)
(0 отзывов(-а))
0.0
kshfsiraj

I can assure you quality [login to view URL] i hope you would to discuss about the Project . I am eagerly looking forward to the opportunity to work with you. Best Regards, Kashif siraj

$140 USD за 7 дней(-я)
(0 отзывов(-а))
0.0
satramdas1965

Hello there I will update your excel sheet as per you requirement I am new here but i have good skills in this field if you want i will give you a sample also Thanks

$45 USD за 1 день
(1 отзыв)
0.0
nelishazoli001

Hi, Thanks for posting !!! I have 6+ years of experience in Web and App development. I have checked The requirement and understand that as well. I have created SIMILAR in past. Do you want to see the DEMO ??? Tha Больше

$277 USD за 2 дней(-я)
(0 отзывов(-а))
0.0
mdgolammostafamo

i want to your work

$155 USD за 3 дней(-я)
(0 отзывов(-а))
0.0