Find Jobs
Hire Freelancers

Erstellen eines Softwares

€8-30 EUR

Imeghairiwa
Imechapishwa over 7 years ago

€8-30 EUR

Kulipwa wakati wa kufikishwa
please try only if you know how to do scripts in google spreadsheets. Excel is not possible Have a look here: [login to view URL] I need an improvement of my Google spreadsheet which automaticly updates my datas by click ------- what does my Script is doing now?? It changes Sheet 1 collumn B-M from Sheet 3 (CSV-Daten) by clicking "SKU" in the navigation which starts a Javasctipt in Google Spreadsheets 1. Sheet 3 (CSD-Daten) you see in collumn A the Name of the product OR the Sizes we have for the Product. you see in collumn B the SKU for the product which is very important you see in collumn D the number of products we have for the size in Collumn A this sheet is updated daily, so tomorrow, there might be more products or less and the same product might be in another row 2. Sheet 2 you see in A:B 1:10 size mapping 001_32 / 2XS in Sheet3 is 2XS in Sheet1 3. Sheet 1 This is the important sheet that is updated automaticly if i Update Sheet3 and click "SKU" in the navigation I include SKUs in Collumn A The Sheet is now uptading automaticly for my given SKUs the next collumms in B: The name of the SKU from Sheet3 Collumn A in C: The number for Size XS for the SKU from Sheet3 Collumn D in D: The number for Size S for the SKU from Sheet3 Collumn D and so on it changes, too the colors (0 = red, >1 green) ..... Often, SKUs don't have all Sizes, then it types in the Sizes in Sheet1 "no" and changes color to yellow Often, SKUs don't have any Sizes, then it types in the sizes in Sheet 1 "no" and changes color to yellow For me, only the SKUs are interesting, which have the numbers, i asked for. Important: i include the SKUs in Sheet1 Collumn A and i'll include more of these SKU and maybe delete some of them, so i need to have the chance of Sheet1 Collumn A ------------------ What do i need. 1. exact the same for collumn "N" - which icludes the new Size "one size" 2. exact the same for collumns "AC" - "BO" which includes new sizes here you can use the same code for the new sizes 3. Collumn "O": Here i need a sum of all products in Stock for these SKU Please use the same colors (no = yellow, 0 = red, >1 = green
Kitambulisho cha mradi: 11527750

Kuhusu mradi

Mradi wa mbali
Inatumika 8 yrs ago

Unatafuta kupata pesa?

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa
Pata malipo kwa kazi yako
Eleza pendekezo lako
Ni bure kujiandikisha na kutoa zabuni kwa kazi
Picha ya Mtumiaji
We have a 1000+ employee in our company. So we can do any kind of project based on all languages and all stream...... We have 3 years+ experience employees for all stream especially C, C++Programming, Java, PHP, JavaScript, Web design, Graphic design, Linux, MySQL, .NET, ASP.NET, MVC, Android, iPhone, Mobile Phone platform. So don't fear anything as soon as possible…. We are heartily welcome our projects.... ...................................................thank you..........................................................
€29 EUR ndani ya siku 2
0.0 (0 hakiki)
0.0
0.0

Kuhusu mteja

Bedera ya GERMANY
Kreuzberg, Germany
5.0
15
Njia ya malipo imethibitishwa
Mwanachama tangu Mac 19, 2006

Uthibitishaji wa Mteja

Asante! Tumekutumia kiungo cha kudai mkopo wako bila malipo kwa barua pepe.
Hitilafu fulani imetokea wakati wa kutuma barua pepe yako. Tafadhali jaribu tena.
Watumiaji Waliosajiliwa Jumla ya Kazi Zilizochapishwa
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Onyesho la kukagua linapakia
Ruhusa imetolewa kwa Uwekaji wa Kijiografia.
Muda wako wa kuingia umeisha na umetoka nje. Tafadhali ingia tena.