excel folrmula required

Closed

Hello,

I regualrly download a backup of my "daily todo list and diary" from my phone into excel to create a weekly timetable that i can print off.

The downloaded db contains all my TASKS and the PROJECT name that it is filed under. i simply want to be able to see them in a dropdown list in a seperate sheet in the same workbook.

Once i find the right person i will give you more details on how to read the attached spreadsheet and exactly which columns contain the data that i require, however for now please look at celll AV180 ONWARDS you can see that all the project and tasks are listed in column BD and the projects are distinguishable from the tasks as column BG has the entry "kCkkhl1o9l" for projects only.

For this project to be successfully completed you need to do following:

1. In the seperate TIMETABLE sheet i should be able to click PROJECT and a dropdown list of all my projects will appear.

2. Once i choose a particular project, the cell below it marked TASKS will also contain a dropdown lists of all tasks relating to the CHOSEN project only.

3. You will not make ANY ammendments to the data spreadsheet AND i should be able to download a newer version of the data whenever i want and the formulas used to get the TASK and PROJECTS will not be affected.

When bidding for this project please mention what experience you have with:

excel forumulas

VB

macros

This is a very easy task and for those experinced in the above skills it will not take you more than 5 minutes so lowest bids considered only.

Thank you.

Skills: Excel

See more: how to take data entry projects, how to get the data entry projects, how to find data entry projects, data entry bd, bd data entry, vb in excel, vb excel, todo list, i need to make excel projects, how get data entry projects, how can i get data entry projects, excel projects, Excel formulas, diary, bd, bidding formulas, excel timetable, excel contains, seperate cell, excel right click, task marked completed, excel cell, create workbook, find excel project, excel print sheet

Project ID: #1369784

Awarded to:

danielgpratidya

Hi, I will help you with the project, although now I could not see any attachment yet, please read pm.

$30 USD in 0 days
(81 Reviews)
5.7

31 freelancers are bidding on average $50 for this job

ShiaFirst

Hi there, First of all, you haven't attached any excel sheet to figure out. But I have totally understood the task and can create a macro or VB program, which will do that. Let me know, if you want me to work on it. Ma More

$30 USD in 0 days
(20 Reviews)
6.1
koolsidz

Excel Whiz here ;) Please see PMB :)

$35 USD in 0 days
(94 Reviews)
5.6
nagybatonyi

If I understood right, downloading always overwrites the old Excel file therefore macros doing the job must be stored in a separate workbook. This is the very solution I offer: I plan to complete the project via writi More

$45 USD in 2 days
(48 Reviews)
5.6
FIBIN

Hi, I am an expert in excel and VBA Programming/Macros in Excel. I have experience working on lot of Excel based projects. I am interested to work for your project. I will make sure that I deliver you the best with More

$30 USD in 0 days
(42 Reviews)
5.3
Krusche

Hello. We offer to finish this small task by the end of the working day. Please check your PMB for our previous examples.

$30 USD in 0 days
(21 Reviews)
5.2
imudita

I have done it. Please see PM.

$30 USD in 0 days
(27 Reviews)
4.7
psprongs

I have extensive experience in data processing using excel, vba. Please check PMB

$45 USD in 1 day
(10 Reviews)
4.5
pyazlm

I can provide the required macros using VBA.

$30 USD in 0 days
(30 Reviews)
4.4
Pichart

I am an excel developer. I am expert in Excel both excel standard and Vba coding. I work with excel more than 10 years. I have viewed your requirement, and plan to do with dynamic Vba...more in PM.

$30 USD in 1 day
(15 Reviews)
4.1
phuongh2t

Please give the project. I have good skill in MS Excel, Macro, VB.

$50 USD in 3 days
(3 Reviews)
3.3
esalem

Hello, please see the PM for details.

$60 USD in 1 day
(8 Reviews)
2.8
adnanwq

JUST READY TO START NOW SEE MY PM

$30 USD in 0 days
(3 Reviews)
2.0
tota999

############ EASY FOR ME ############# ___________________________________________________________________________________________

$30 USD in 1 day
(2 Reviews)
1.8
rajesh198

Please check your message box

$35 USD in 1 day
(0 Reviews)
0.0
ViktorBatalski

Hello, please check PM.

$30 USD in 1 day
(0 Reviews)
1.0
Shyamaraj

Can do the task in 1 day

$30 USD in 1 day
(0 Reviews)
0.0
autoinnov

I have written several excel formulas in past for a high end analytic work for an IT giant.. I used to be a process developer where I also worked to automate process (mostly excel based) using VB & Excel Macros... one More

$30 USD in 1 day
(0 Reviews)
0.0
Amnateeb

Financial modeling expert!

$30 USD in 1 day
(0 Reviews)
0.0
ankitdharamshi

HI am working as Sr Executive MIS and i believe i fit for this work

$30 USD in 1 day
(0 Reviews)
0.0
jotham82

Given the opportunity i will deliver in time. I have knowledge of excel formulas and excel as a whole.

$30 USD in 0 days
(0 Reviews)
0.0