Select a date then auto fill from worksheet

Looking for formula

1. In a worksheet I select a date [28814] using a dropdown box H33 in worksheet called "Input"
2. Using this date the formula looks for worksheet called [28814] and selects the data in F205
3. Places this figure in "Input" D39

Hope that you can assist with this one

Please Login or Register  to view this content.

put this code in D39

Sorry cannot get that to work
Need to put date in H33 in "Input" workbook
The search for worksheet tab [e.g. 28814] to F205 in 28814 and place that number in "Input d39

can you post the workbook then I do it for you

Here is a rough of what I am trying to do

Assistance appreciated

test.xlsx

it works perfect

give me a sec

well it's because you don't write your sheets as dates or convert the cell with the date and you had a space infront of the formula

you can do this to ways you format you cell like I did in this one or write the date in the sheet name like in the cell

Thanks for that
What would I have to do to make 28814 a date format in Input F33 but the Tabs remain 28814 or is it better to make the tabs 28-8-14

right click and format cell to date or what you prefer.

Problem is that if I make F33 a date format the formula shows an error because it is looking for the TAB with the same format
I am reluctant to change the TABs because other formula use that format e.g. 28814

Any suggestions?

look at oeldere post:

Please Login or Register  to view this content.

Really appreciate the assistance - Thanks

This still has me beaten.
I have added an example for considering
The problem is converting a date to a number with it working with a formula
As always assistance appreciated

It all starts with the date
I don't care about the format provided it works the numbers at the bottom of the sheet - data 11

Sorry - F18 will always be a date
The tabs at the bottom are dates 28814 29814 and so on
I am wanting that when a date is selected or entered in F18 it copies to h33 in a format which drives the Formula in d39 to D43
I don't have a problem with the formula in D39 to D43 being linked directly to F18
I originally thought I could link the date and convert it to a number so it would drive the formula in D39-D43 but I cannot get it to work
Sorry for the confusion

@ oeldere
I wold like to explain his requirement , i think u would have understood the same
Just trying to explain it again , can i ?

Punnam

As per Post 18
1) The OP want to change only the data in F28
2) Please check the sheet 4 it has been started with Date in Cell A1 which also has a date filled
3) "it works the numbers at the bottom of the sheet " The same will be the name of the sheet i.e if F28 = 28-08-2014 the sheet name will be 28814
4) If the data has been entered in F28 it should be converted to the sheet name in H33 and from their , he should be able to get the data form various sheet in his workbook
5) Even i am not having Ideas of "Data 11"
Punnam Ravi

Hi
Addressing this part "I am wanting that when a date is selected or entered in F18 it copies to h33 in a format" u can achieve by the below formula
=DAY(F28)&MONTH(F28)&RIGHT(YEAR(F28),2) use this in H 13

Punnam Ravi

That is perfect.
I thank you very much
You are brilliant

If that take care mark the thread solved using the thread tools & u can thank me by adding reputation . By Clicking "ADD reputation".

Punnam Ravi Kumar

Checked

Yes it will show 2614

Punnam