Search results

Thank you Rudra, Ill check that out. :) Much appreciated.

Hi GN0001, The tip above is for when you want to post a bit of code or macro. You put your code between the the code tags and it will come out formatted as code. You will not see [ ] The code here is posted between them. Hope that helps. ps the code is just an example and nothing to do with your...

Thank you Hui,:awesome:, I must have tried every thing except that. I think I was trying to activate it instead of select. I knew it would be simple but if you dont get it quite right it dont work :oops:

Hi i have some code which extracts the expenses from a list of combined income and expenses. It runs great if I manually select the correct sheet ("INCOMEXPENSESa") first. If I dont select the right sheet it creats havoc on the active sheet :) Im sure this should be simple but I cant seem to get...

I was going to tweet my weather data which I keep in excel, is that so bad? :oops:

Exel Zoom has a twitter cropping sheet that also opens up twitter for you.

Hi New VBA user, If you upload a sample sheet, it will be easier for folks to help you. :)

Hi Rob , If you provide sample worksheets of the data before and after Im sure one of the Ninjas will be able to suggest a method to help you do this. They need to know how your data is laid out and what you want in the consolidated sheet. :DD

I am sorry you are going elsewhere. There are many brilliant excel helpers on this forum. A sample file with the layout you required would have made it so much easier for one of them to help you and those of us that are still learning and lurking may have learnt something too. :confused:

:awesome:!, :awesome:!, :awesome:!

:awesome: , Hui

Congatulations Somendra Misra, :awesome: Work, Ive read a lot of your posts .

I think he means the one you are about to post :) so he has something to work with.

Venkata, thank you for that code, just did a great job for me, removing unwanted text.

monalisa or mdtje, I think the OP has yet to come back, bit of confusion here I think :confused:

Hi, after multiple tries I finally got the toolpack loaded and now the formula works. Thank you so much for your help, have a nice day.

Ronin, hope you are not lost. :)

HI, Sir JB, Many thanks for the formula, but I am having trouble enabling the Analysis toolpack. I have the excel cds but keep getting errors. IM sure I had them on my previous computer and they worked ok but I may need to uninstall and reinstall Office 2003 on this Win 7 puter :(

Hi I an subtracting 15/9/2011 from 15/2/2014 to get number of days old. I then divide by 365 to get years and get 2.42 yrs which I then use "round up" to get 3. I then put an R in front to get R3, (=R&" "&G3 etc) ie rising 3yrs. I have done this in three steps using helper columns. Is there a...

Hi, How do you want this information presented in word? You may needto supply a word doc so we know what to do with your data.

Abhijeet, I think maybe you need to supply some sample files and and specific questions about any problems you are having trying to do this. Your post above does not explain what problems you are having.

:C:

Thank you for sharing. :)

And I am even more of a Dinosaur, Im still on 2003, but was thinking of upgrading to 2013, maybe I wont bother.

Hi, this thread may help. http://chandoo.org/forum/threads/filling-in-random-blank-cells.13321/#post-78406