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
技能： 数据输入, 数据处理, Excel, Visual Basic
查看更多： make accounting worksheet excel, make excel conceptual worksheet individual data values statistics, make excel worksheet standalone, make excel worksheet standalone program, hello all i need is 90 into my skrill acount bcuze i cant withdrall my, hello everyone i need a logo for localvender, hello freelancer i need simple logo design and i have a pretty good idea what type of design i want, hello freelancer i need simple logo design and i have a pretty good idea what type of design i, hello i need a logo for my site details in private, hello i need a presentation like this original presentation, hello i need to create a logo and a name to put on my clothing brand, hello i need urgent typist you just have to write in notepad from image i, i have 12 scanned images and each one has 30 rows and 15 column i need you will type the data from images to excel, i need a excel spreedsheet prepared, i need an excel expert to come to my office, i need an excel expert to organize some data for me i need to combine a long list of 1000 items into model units etc this is a s, i need an excel expert, i need to make excel projects, i need an excel expert to come and fix up our spreadsheets for a few days johannesburg, i need an excel freelancer