¥140.00元 I need someone to make my excel worksheet stable

发布于:2018-09-15 来自:freelancer 截止交稿时间截止交稿时间 2018-09-15 关注:262 评论:0

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

查看更多: 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

免责声明:

任务易所有内容均为威客和外包行业网站提供或收集于互联网公开的信息,目的是给在网络上工作的威客和兼职人员收集更多的免费工作信息,以帮助更多的人自主就业。如果有内容触及您的权益,请给我们发邮件(kf@renwuyi.com)并附上具体网址和说明,核实后我们将立即删除!对免责声明的解释、修改及更新权均属于任务易所有。

你觉得这个任务肿么样?

我坚信,评论可以一针见血。
暂无评论
  • 评分:
    3.0分
  • Freelancer.com是世界上最大的自由职业、外包和众包市场,拥有许多用户和项目。我们将来自全球超过247个国家、地区的超过 9,471,792 雇主和 自由职业者联系在一起。通过我们的市场,雇主可以雇用自由职业者完成例如从软件开发、写作、数据输入和设计到 工厂、科学、销售、会计和法律服务的工作。

你可能也对这些任务感兴趣

  • 暂无数据

便捷搜索

价格
日内的任务