Search results

Hi I dont usually use big formulas so am a bit lost trying to find a solution to this request. I dont even know if it is doable. Any pointers to help much appreciated. If Sheet1!G2:G says "save" Then lookup the Value that row in column A , then look up Sheet2! B2:B for the same value select...

Congatulations and many thanks to all the new Ninjas:awesome::awesome::awesome:

If you are still in need of help, consider uploading your file.

Congratulations, :awesome: is that a Red Peak avatar ;)

Happy Birthday. hope you have an :awesome: day.

Hi, How are you getting your data onto the contact sheet. If you were using a "user form" you could update both sheets at once with vba. Otherwise you could use formulas on the second sheet. Will the data always be in the same format?

Hi, Could you put the user form in your excel file so we dont have to rebuild it? Then it would be easier for someone to help you.

You could build your own form to suit what you want.

Do you have a sample file to upload?

Hi, have a look at this form, lots of ideas in there. https://netmerkez.wordpress.com/excel/create-a-advanced-userform/

Glad you got it sorted. Thanks for updating :)

If you still need help you may need to upload a sample file so as to get a more precise answer.

Hi Kym, a sample file would help those wishing to help you.:)

Hi Nicole, if you upload a sample file with your requirements Im sure you will get some help soon.

Congratulations Luke, great job.:awesome:

Hi Cruiser, since the OP hasnt been back I would suggest you create a new post with your query. Im sure someone will be able to help.

Congatulations Deepak, thanks for your many contributions.

Hi have you had a look here. Lots of info on dependent drop downs etc. http://blog.contextures.com/archives/2014/03/13/dependent-drop-down-lists-with-tables/

I dont always have time to open and read interesting looking threads. it would be great if I could add them to my watched list so i could go back and read them later by clicking on an icon by the header?? as I scroll through the latest posts. Thoughts on this?

All working good now, I subscribed using Miro and they are all there now :)

Hi Hui, I have only just started to listen to some podcasts and as the radio ones I tried worked great (Not sure what I did..)I thought I would try the Chandoo ones . I will try again . Thanks for you help.

Hi, Does anyone know how to get the pocasts to play in"Miro" I cant seem to upload them. Thanks, L

You may need to select "visible cells only" ??

Wondered why Hui wasnt on here tonight, must be out celebrating. happy birthday Hui!

Have you considered using a Pivot table? It may give you what you need