Search results for query: *

Hi I would like to do a quotation sheet whereby a user types in the qty and code. The VBA would then lookup the description of the item and return it to the spreedsheet. Currently I am using excel and two sheets with vlookup, but this does not offer much protection of the descriptions (5800) of...

Hi Combo I pretty much lost U here..Now do some formatting. Right click each of row fields and select field setting (probably, I have non-English version of excel) and then select "none".The Columns have got headings.. CODE DESCRIPTION PRICE SUB CATEGORY. I just can't seem to get it...

Hi I'll send it. I found a feature on Excel , Microsoft Access Report..It imports the information into an Access database and allows you to do a report.It even puts a BUTTON on the excel spreadsheet....AMAZING...got to see it to appreciatte it.

thanx for your time, but I don't even know where to start implementing your code.My Excel is not that advanced.If I could email the spreadsheet to you , it would help.How adventures do you feel today.

I have tried pivot tables, but I keep getting totals of the count of the amount of rows in the table.

COuld someone please assist me with reading from a text file in a macro without all the opening and closing appearing to the user.None of my books seem to cover this topic.I know you have to use Workbooks.OpenText Filename:="C:\dir\filename.txt", Origin:=xlWindows, _...

How would I sort the following in excel: code description Main category Sub Category 1234 apple fruit tree 4567 orange fruit tree 3256 strawberry fruit ground 7890 potatoe vegetable ground 9876 gemsquash...

HI PATRICIAANE If you want excel to reloop the formula that is without having to change your sort order and find your matches, then you must enter $ =vlookup(A1,$B$1:$C$2,2,false)