I need someone to make my excel worksheet stable


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


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.

Thank you!

Warm regards, Jan

Znanja: Vnos podatkov, Obdelava podatkov, Excel, Visual Basic

Več: excel spreadsheet design best practice, bad excel worksheet design, excel file slow to respond, steps of planning a worksheet design, excel spreadsheet problem solving, excel spreadsheet problems, planning a spreadsheet, excel shared workbook problems, 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

O delodajalcu:
( 4 mnenja ) TORRANCE, United States

ID projekta: #17771083



Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( Več

$235 USD v 3 dneh
(664 mnenj)

37 freelancerjev ponuja v povprečju za $154 na tem delu


Jan, Can you send me your excel file and google sheet so i can check that and can get exact idea about to fix the all things. Please send me a message so we can discuss. Highly experienced in Excel Programming, Exce Več

$250 USD v 3 dneh
(286 ocen)

Hi Sir/Madam, It is being my pleasure to introduce you to me. I am expert in advance excel. I have excellent knowledge of advance excel. I know many things in excel like Formulas (Countif, Sumif, Index match, Vlooku Več

$160 USD v 0 dneh
(335 ocen)

Hello Sir, I am the expert freelancer here. I am on the 6th position through out the world to deliver the quality job. I have deliver here more than 400 + projects with 100% client satisfaction. I can help you Več

$250 USD v 4 dneh
(312 ocen)

Hi Jan, I love Excel and perfected my Excel skills by doing this kind of job repetitively for more than 5 years. I have strong attention to details and I'm also deadline driven. I consistently turn in above average Več

$300 USD v 2 dneh
(315 ocen)
$211 USD v 2 dneh
(115 ocen)

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

$100 USD v 1 dnevu
(186 ocen)

Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fifty excel vba projects in the recent eight months. Have helped a few other MAC customers in obtaining a VBA solution for their r Več

$250 USD v 5 dneh
(76 ocen)

1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex mar Več

$200 USD v 3 dneh
(59 ocen)

Hi, I have expertise in Excel, formulas and macros. Please share your Excel sheet/ Google sheet link so that I can check the issue properly and can provide you permanent solution for your problem. Please allow me th Več

$155 USD v 3 dneh
(59 ocen)
$50 USD v 1 dnevu
(66 ocen)
$50 USD v 1 dnevu
(43 ocen)

am not a random bidder.. Please ping me if you are interested with my proposal and will have teamviewer session to fix all your needs.. thakn you..

$250 USD v 3 dneh
(23 ocen)
$155 USD v 3 dneh
(3 ocen)
$55 USD v 1 dnevu
(2 ocen)

Hello Sir, My name is Manish and i am from India. I work as a Freelance Excel, Access, Financial Modeling, Power Query and Power BI professional. My work is my biggest passion. My skills in Excel, Access, Financ Več

$35 USD v 0 dneh
(14 ocen)

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.

$45 USD v 0 dneh
(7 ocen)

Dear Sir, Please be assured I can do this rask very fast. Please message me immediately to start right away. Thank you...

$35 USD v 2 dneh
(2 ocen)

I am excellent in ms excel, ms word (constructing database, managing data, analyzing and processing data). I am a quality analyst in a BPO Company that deals with US based accounts (Amazon and PayPal) which work Usi Več

$222 USD v 3 dneh
(1 Ocena)

sir i am new to freelancing but i have good typing skills and ms office knowledge. I need your feedback for my career about my work. I am giving assurance i can finish your work within the time as i mentioned in the ab Več

$155 USD v 3 dneh
(0 ocen)

Hi I am a market research specialist and deal with loads of data daily. I could do this work and make it easy for you.

$110 USD v 2 dneh
(0 ocen)