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.
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)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.