I need someone to make my excel worksheet stable.
I am on mac with Office for mac 2011 in SWEDISH!
I have an excel file with a few sheets.
I gather info into a Google Sheet
I COPY/PASTE that into what I call the I call that the PASTE sheet in EXCEL
I ALSO fill out some PROJECT specific info in my PROJECT sheet.
All info from these two will go into three different sheets:
Here every row has more columns and are copied several times into new columns.
I will export this to a tab delimited txt file
Here are two sheets that have an insane amount of columns
This way i can get a lot of info on one row.
Same thing, export as tab delimited text file
MY BIG PROBLEM:
I insert and copy, many times over INFO THAT DERIVES FROM THE 1st GOOGLE SHEET DOCUMENT. This info shall NEVER change in FORMAT. I need leading zeros, MM/DD/YYYY dates etc to remain the same REGARDLESS of how many times i COPY/PASTE or copy into the cell
with using for instance "=A1".
I need to know how to do it or have one do it for me. Bset solution for me would be to have the format in every cell in the whole excel file LOCKED and PROTECTED regardless of how the info is entered.
Also, I need to mention, I have had to use some $A$1 to maintain line specific references and some need to not have that. These should be the same, but still lock format to that of the cell.
All this seems to live its own life, and I end up having no leading zeros, sudden decimals,
dates are showing the result of two divisions etc.
In kind of a hurry with this.
Warm regards, Jan
38 freelancers are bidding on average $155 for this job
Hi Jan, Greetings. Would you kindly attach the file that i could ask questions in order to get a stable, organized file. Plz let me know if you like to get it done fast. Thank you. Sincerely, ahmsuza
Hello, I can help you with your excel problem, please tell me more about it in message and send me the file or the example so I can start working and send you the file back as soon as possible.