Search results for query: *

Its not about resizing its about restructuring it...... I suggest you print the images i posted and read what someone else posted again... Then you can ask Microsoft directly why this is... And then do a google search for Denormalized data....

It's because Excel does not import the XML data properly( for an immediate export.. You will need to adjust it before you can export it. It needs to be set up a little bit further before you can export it... This should be a once shot deal. You dont need to do it every single time... This is...

I am sorry I never realized this before. I have noticed the stars on onther posters. But never understood why... I have searched this board extensively over last year and half and I can assure you that many (far many) than 28 deserve a star. I have learned alot just by reading and searching...

Nevermind. I think I see it now... Its during the thread itself.. OKAY got it!!

Skip You lost me. I do not see anything on my screen that looks like what you had said. I am very grateful for all the help I have received. Extrememly grateful... You lost me on last post... I cant see what your referring to????

Skip your think is not a link... I am missing something..

I notice that over the past year and a half, you have posted 28 threads and have received many good tips related to your stated needs. Yet, you have responded NOT ONCE, to ???? Skip I really do appreciate the help I have received.. I am not certain what your referring to... I see your link...

I still thank you, You helped me in another way that you are not aware of it... Thank you

Thank you so much both of you. Got it working. Beautiful.. Very simple when you know what to look for... Thank You! Appreciate both your guidance and experience.

I have a userform that Pulls data from the spreadsheet as well as saves it back to the spreadsheet if I change an Information.. I would like to be able to view the character count as I enter new text inside the userform. I have tried many things already. And what I am doing does work. But I...

Thank you for posting that,I have to educate myself a little bit with this.

Please bare with me I am brand new to Javascript, I have done some other coding with VBA. I am trying to build a shipping calculator to post on a Website. I am little confused on how to do something, Or how to make it happen. I am short on some of the terms. I eliminated alot of the code...

I had a similar problem with the denormalized data. Here is what you do to fix it: this is based on the file you attached: Step one: Select any cell inside the Blue Box (click) data>>>List>>>Resize List (a little dialog appears) =$A$1:$N$4 Change to =$I$1:$N$4 Step2: Remove data in cells...

Goodmorning, I have some code posted below that I use to answer some questions that I typically get. In Outlook I have a folder named NYF Questions, I have some subfolders added to this folder. How would I alter the code to extract Email from one of those subfolders.... I have now Set...

Never mind, I found the answer, For some reason it was not working when I tried to edit my import query, However when I use a brand new sheet it works fine...So just added a worksheet and renamed it..

I do some sales in Europe and the address is typically supplied. There are alot of different characters in thier alphabet.not like USA. I download a csv file (do not open it and run it through my tool I created using a query in excel. I have it set to text and I know the csv file (when opened...

Can anyone recommend a way to change the color of a textbox on a userform. I am pulling some data off my excel sheet (viewable in the textbox) The conditional formating I have set on my sheet does not carry over. Is there a way to achieve this? Any insight would be appreciated, Thanks

I have a spreadsheet that I would like to add a button to copy the data displayed in text box next to it quickly in a click. My userform is alot like if you had a spreadsheet and went under data>>>Form.. It has the next and previous buttons. Is there a way to make a button on same userform...

yes It is also the easiest for me to understand as well. Thank You both appreciate it. Sometimes dont see the obvious things.........

Skip I am using an If exact Vlookup formula such as this; I am quite comfortable using this formula I use it alot. I am not trying to simplfy this formula Itself, my problem is I am pulling one column at a time for each pricing Weight, then using other formulas to determine what weight to...