Search results

Hi All, I would like to extend my excel skill by being able to use SQL in excel & VBA in more advanced way. I have no idea about SQL and not sure if that would be a good time investment. I was looking for some basics stuff on the net and couldn't find something interesting. Can you guys help...

Hi mprasad, It would definitely be good to see the data so that we all can work together on achieving your goal. You can create dummy dataset if you want to. Cheers !

Hi Luke, This is awesome !! Thank you very much for your time. Regards.

Hi all. This title might be misleading but i don't know how to define it. The issue is that i have got an spreadsheet with loads of formula and macros. The nature of my spreadsheet is that I have to drag down the formulae to do the calculations and then sort the values out base on the manager's...

Looks like you are right OleMiss2010. They are not saved as images and being saved as links. I was wondering could we use something similar to this to force excel to embed the images within the document ? Save With Document:=True Or is there anyway we could modify this code to make it work...

For i = LBound(Filename) To UBound(Filename) With curWks.Cells(i + 1, 2) Set myPict = .Parent.Pictures.Insert(Filename(i)) (few codes for alignment) End With Next i I am using this to insert pictures using loop as i, so that i'll add multiple images. This is really weird as it worked...

Hi, My apologies for posting this on wrong one. I am using a VBA to add multiple images in a specific column and at first it seems ok but once you save the spreadsheet and remove the original folder (or send it to someone else) where the images were, the images in the spreadsheets are gone...

Hi, I am using a VBA to add multiple images in a specific column and at first it seems ok but once you save the spreadsheet and remove the original folder (or send it to someone else) where the images were, the images in the spreadsheets are gone replaced by this message " The linked images...

Hi xld, Thanks for share the link. This is quite interesting stuff you've got there. Unfortunately this is something different to what I am looking for. What I am looking to do is something similar to Mr.Daniel's work http://www.excelhero.com/blog/2010/06/excel-optical-illusions-18.html...

Hope everyone is getting ready for the weekend for a blast ! I have a one question before we hit that weekend. I was trying to create something like when u open the excel spreadsheet a pop up message will appear saying " Welcome to ABCD Dashboard " possibly with the nice animation and will last...

Thanks Mr Hui I am refering to the links you've mentioned and I am pretty sure i'll have few more questions if you don't mind. Thanks again for your help Cheers !!

I though it would be interesting for us to have this technique (or post) at chandoo.org. What I was thinking was would it be possible to have at line graph moving automatically (something similar to google spreadsheets). So we can have our normal scroll bar for manual range selection and if we...