Several on this forum have helped me with Vlookups in the past and for I am most gratefull.
But rather then continuing to have someone send me the formulas, I think if I understood what the instructions in the lookup actually do, I will be able to modify the vlookups I already have...
I have 2 spreadsheets A and B - in the same workbook.
Spreadsheet A is sorted alphabetically (by product name).
Spreadsheet B is sorted numerically (by product ID) and has quantities (how many items are in stock).
I need to pull the quantities from spreadsheet B into...
Thanks XCubed. Please don't be too impressed with me writing macros. Excell has a developer tool which captures what you are doing and writes the code (VB?) for you. All I have to do know how to do it manually 1st with no mistakes along the way and then turn on the capture macro tool. I...
Thank-you again XCubed. I hadn't used a custom sort before but was able to figure it out using your instructions. I sorted Col A from smallest to large and then Col D from z to a which did exactly what I needed to do. I captured all of my keystrokes into a macro (typing out your formulas and...
Thank-you XCubed! Your formulas combined everything but I need one more change. I need to have the combined products stored in the 1st instance of the 1st appearance. Can a 3rd step be added to move the combined prodcuts to the 1st line where we started?
(I may have finally figured out...
Hello, not sure how to explain this but hopefully this will work.
I need to combine the contents of all the cell Bs when cell A has the same contents (in this example 2222 etc.).
line 1 2222 object
line 2 2222 box
line 3 2222 something
line 4 2223 circle
Hello, I need help with one more formula in Excel.
If the contents of A1 is less than 75.00 and greater than 0.00, populate B1 with 8.00
Col A________Col B
Hi, I need help with a macro. I want to copy the contents of the cell above into the cell below if the cell below is blank.
so it looks like this after the macro runs.
Some of the lines do not have an 8 in colume D. IF D1=8, add new line and populate the fields. If D1 does not equl 8 than do nothing. Again I have no idea how to write this.
Thanks for responding. I've always had good luck here which is why I posted my quesiton here 1st.. I'll see if I...
I'm afraid I have no idea what a changesheet event is. When I googled it, it indicated that it is used to trigger an event when the contents of a cell changes.
Let me ask this a differant way.
What I'm looking for is either code or a formula that will add a new line whenenver...
WIndow 2007, XP
I need some help with an Excell formula.
I need to add a new line everytime a particular cell in a line has a certain value.
Prod Teapot ID400 8
If colum D=8, add a new line and populate cell 2B=SP and cell 2C - XXXX. The end...