Search results

A more manual but effective way... http://www.exceltip.com/st/Sorting_by_Columns/248.html I inserted a row above the current column headers and numbered the cells in the order I wanted and poof!

Oh no, I am a beginner to be sure. I have "poked around" in the past, but not "written" anything. I am just now starting to get more seriouse about it. I am now at the point where I can "look" at code and know what's going on and then adapt it to fit what I want to do. But, I do not "write" my...

I'm not sure it's the same thing? I want to "loop" through the range looking for multiple values and paste those cells entire rows into another sheet. Here is what I have found that seems to work: Sub FilterRange() Dim myrange As Range Dim CurCell As Object Dim Cell As Range Dim rngOutput...

I am just starting to learn VBA. What I'd like to do.. 1. Find last used cell in column "A". - I know how to do this 2. Cycle through the range and finding specific values (in my case I am looking for district names (North State, South Bay...). 3. Once found I would like to copy that district...

Everyone will have a different opinion. I have never used one myself, but have looked into them and played around with them. So what it's worth, here is what I know... Big names in what you are looking for are Zen Cart, OSCommerce and I think Cube Cart (?). Best of all they are free of charge...

I am at square one with this (and I mean square one). I would like to learn more about these forms but am unable to find a good tutorial. Any ideas would be great.

What if you were to use sessions to track the car#? I am pretty new to php, but I do know you can track a user and their changes from page to page using sessions. Cookies may be the answeer as well if they want to exit and revisit the site and then start from where they left off.

Should be? rather strong choice of words I think. How about "could also be"? Where did you pull that 40% figure from? While you may or may not be correct in your recommendation (I really couldn't tell you) to come out and say "should be" is kind of silly in that as we all know there are many...

Thanks for the tip brian :D I'm not really sure about the "--" as far as the technical stuff goes. I know that one of the things it does is it allows you to sum up a range even if text and numbers are in that range. Whenever I can't get sumproduct to work, I put in the "--" and it usually...

Try this... =SUMPRODUCT((B2:B7=A12)*(D2:D7))/SUMPRODUCT(--(B2:B7=A12)) Note the double unary operator ("--") What's up with the grin face?

Try putting this in your sample sheet cell "B11"... =SUMPRODUCT((B2:B4=$B$2)*(C2:C4>=J16)*(C2:C4<=K16)*(D2: D4))

This use of sumproduct is amazing and I use it all the time. For a detailed report on it check out... http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Try =sumif() (look it up in excel help for a complete understanding of it).

How about select all on website and copy and then "paste special" into ms word and pick HTML Format.

I do something like this at work. I have a "master" file and it gathers information from 60 sheets. When I want my master file updated I just paste the new sheets into the folder and overwright the old ones. You can do this if your results are numbers (counting or summing) very easy. I use the...

mark, If you have a busy site don't you run the risk of picking up the wrong id? That's why I thought about sessions as that insures an accurate result.

Wouldn't it be easier to use sessions?

I looked at what you had listed and I guess I'm so new to MySQL I'm confused at what these apps do. I was investigating SQLyog as an example and it seems it is a front end for MySQL and I am not quite sure why one would need it, except to insulate you from the internal workings of MySQL. I guess...

I little trick I learned on converting is to select the column and use the text to column feature. That works when changing data types doesn't and is very easy. HTH

I'm not sure I understand everything with this but to identify every 4th row can't you do... =mod(row(),4)?