Fermé

Google Sheet to Excel and Vice Versa

Right, here we go, so to explain this as clearly as possible. I work in a company that uses excel sheets that I have coded to simply reference other sheets and documents to produce certain calculations etc. Where we are attempting to move to is a google sheet which has its problems. This is because excel uses reference codes for certain results, and google uses other references obviously from a copyright point of view.

What I am looking for is to see if a google document can read an excel via a code which in turn communicates between both programs when you import it to a google doc.

I am not sure if this can be done and also the level of complexity may be far and beyond what is currently available out there in the market, purely from a google and Microsoft issue to allow the programs to do this.

Firstly I want to establish communication of how and if this can be done, then potentially after I have been satisfied with the response, move forward with an action plan if is can be done. I have sheets that I uploaded that I want to merge through to a google sheet, as you will see, if drops the references, I will also have to share you into my document that sits live in google drive. I have passwords locked on my excel that I can provide, yet as we all know it is easy enough to crack them.

Thanks

Heath

Compétences : Excel, Google Chrome

Voir plus : excel macros google sheet, google excel sheet, data excel sheet macro, find entry excel sheet, excel sheet cities world

Concernant l'employeur :
( 5 commentaires ) Browns Plains, Australia

N° du projet : #8483108

28 freelance ont fait une offre moyenne de 140 $ pour ce travail

srinichal

I am an expert in delivering custom software and scripts willing to discuss further abut the project details

231 $ USD en 5 jours
(14 Commentaires)
5.2
AlexandrK1

A proposal has not yet been provided

250 $ USD en 7 jours
(13 Commentaires)
4.5
someka

What about to create all referencing excels in google sheets? You dont need to recruit me now. Drop me a message and i can make a trial study for you. If you get happy, we can proceed. (as i want some good reference Plus

94 $ USD en 2 jours
(37 Commentaires)
4.7
TonmoyRoy111

A proposal has not yet been provided

138 $ USD en 3 jours
(29 Commentaires)
3.9
citijayamala

i am an expert in Excel and can work on google spreadsheets as well. i have sound knowledge in Google docs and Excel and well. Jayamala from India Hire Me

98 $ USD en 3 jours
(17 Commentaires)
4.0
barkatmulani

I've been working in developing Google Spreadsheet Apps. since last few years after having extensive experience working with Excel. I started working in Excel since the start of my career in 1998. MS Office used to Plus

90 $ USD en 3 jours
(6 Commentaires)
2.9
kapekape

I AM AN EXPERT IN AUTOMATION, EXCEL, VB AND MACROS SKYPE = kapekmonho ph. 0836705645 My solution to this problem is to use to use VBA in excel create text file to record all reference’s in a formulae in a (row colu Plus

277 $ USD en 10 jours
(6 Commentaires)
3.4
Tanveer2u

A proposal has not yet been provided

155 $ USD en 3 jours
(0 Commentaires)
0.0
subrata4

A proposal has not yet been provided

244 $ USD en 3 jours
(0 Commentaires)
0.0
akousor

I have been working in excel for the last 10 years. My speed of typing is excellent. Some are the skills that I have acquired in excel are: Pivot, If formulas, Calculations, Charts, V look up, Validation, Conversion et Plus

122 $ USD en 3 jours
(0 Commentaires)
0.0
joniter

I was pleased to learn of your need of a data entry person. I am a degree holder in Business Management. Since intermediate year in school to my current job , I' ve been exposed to computer application such as MS Word Plus

155 $ USD en 3 jours
(0 Commentaires)
0.0
kdoffice365

A proposal has not yet been provided

155 $ USD en 3 jours
(0 Commentaires)
0.0
amitchaule78

I already worked like this project before. and I have vast industry standard experience as well. I have to deliver the project on time.

166 $ USD en 4 jours
(0 Commentaires)
0.0
riyadi80

I have a good excel skill and attention to detail which may help to finished the task according to the timeline

111 $ USD en 3 jours
(0 Commentaires)
0.0
thevijaysingh

A proposal has not yet been provided

155 $ USD en 3 jours
(0 Commentaires)
0.0
jatinpatel05

I found your problem statement interesting I have tried to do same thing using csv.. I found our that we can write code on Google drive and can load code to Google sheets which helps us to do additional operation which Plus

56 $ USD en 15 jours
(0 Commentaires)
0.0
sagarssj

A proposal has not yet been provided

155 $ USD en 3 jours
(0 Commentaires)
0.0
vishvant07

An evaluation of the device cannot be performed as the device was not returned to the manufacturer. Additional information (including x-rays and medical records) has been requested. Should additional information become Plus

155 $ USD en 3 jours
(0 Commentaires)
0.0
kumdin80

A proposal has not yet been provided

155 $ USD en 3 jours
(0 Commentaires)
0.0
Sevaram1986

A proposal has not yet been provided

111 $ USD en 2 jours
(0 Commentaires)
0.0