Виконано

I need someone to make my excel worksheet stable

Hello!

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:

1. MASTER

Here every row has more columns and are copied several times into new columns.

I will export this to a tab delimited txt file

2. HORIZONTAL

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.

Thank you!

Warm regards, Jan

Навички: Введення даних, Обробка даних, Excel, Visual Basic

Деталі: 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

Про роботодавця:
( 2 відгуки(-ів) ) TORRANCE, United States

ID Проекту: #17771083

Доручено:

jaylancer43

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 ( Більше

$235 USD за 3 дні(-в)
(636 відгуків(-и))
8.3

38 фрілансерів(-и) у середньому готові виконати цю роботу за $155

Webxpert4u

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 Більше

$250 USD за 3 дні(-в)
(266 відгуків(и))
7.8
semi786

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 Більше

$160 USD за 0 дні(-в)
(297 відгуків(и))
7.7
KulfiSoftwares

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 Більше

$300 USD за 2 дні(-в)
(307 відгуків(и))
7.5
schoudhary1553

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 Більше

$250 USD за 4 дні(-в)
(295 відгуків(и))
7.7
$211 USD за 2 дні(-в)
(103 відгуків(и))
7.0
bdoutsource

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 за 1 день
(180 відгуків(и))
6.6
periyannas

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 Більше

$250 USD за 5 дні(-в)
(62 відгуків(и))
5.5
TechnoGuruu

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 Більше

$155 USD за 3 дні(-в)
(50 відгуків(и))
5.3
citijayamala

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 Більше

$200 USD за 3 дні(-в)
(54 відгуків(и))
5.3
vmadhavan15

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 за 3 дні(-в)
(23 відгуків(и))
4.8
$50 USD за 1 день
(39 відгуків(и))
5.1
$50 USD за 1 день
(53 відгуків(и))
5.1
$155 USD за 3 дні(-в)
(3 відгуків(и))
3.4
dataexplorer

"Hello, I am happy to inform you that I have read your project description and understood all of your required requirement. I'd like to help you with confidence and satisfying results. I have professional working he Більше

$200 USD за 7 дні(-в)
(12 відгуків(и))
3.1
manish1988ag

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 Більше

$35 USD за 0 дні(-в)
(14 відгуків(и))
3.2
maguirrer

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 за 0 дні(-в)
(6 відгуків(и))
2.4
lolo2222

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

$35 USD за 2 дні(-в)
(1 відгук)
0.5
mainebolante23

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 Більше

$222 USD за 3 дні(-в)
(1 відгук)
0.2
kumarswapnil01

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 за 2 дні(-в)
(0 відгуків(и))
0.0
nandeeswarreddy

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 Більше

$155 USD за 3 дні(-в)
(0 відгуків(и))
0.0