Question and Answer tutorial

Hey, i've tried to figure this out, and its been pretty hard to get responses. If you look up rob36, you can see other posts i've done regarding this, but i'll reiterate, hoping to at least get a few views this time.

essentially, my first row contains titles; "Item number", "Item description" and then from columns F to BE, i have a number listed which represents a week/year, and then many many rows of inventory receipts for specific item numbers. 20926 represents week 26 of 2009.

What I am trying to do, is allow for the user to enter in the week and year they desire on a sheet, and then the top 10 for that week would be automatically generated for them.

currently I use:
=LARGE(Inbound_Receipts!BE:BE, 2)
to obtain a top inventoryvalue, and:
=INDEX(Inbound_Receipts!A:A,100000*MOD(LARGE(((Inbound_Receipts!$BE$2:$BE$65000)+(ROW(Inbound_Receipts!$BE$2:$BE$65000)/100000)),ROW(A1)),1),1)
to obtain the item number corresponding to that top inventory level.

As you can see, I currently am manually referenceing column BE, and would like it to be able to automatically reference the column based upon what they enter (probably the two values and then CONCATENATE). I'm not sure if hlookup would be used in this, and to be quite honest, i'm completely stumped. I can provide whatever is needed, but those two equations listed are the meat of what i'm trying to accomplish, with my guess being that a few hlookup formulas will need to somehow be needed, although i'm really unsure.

PLEASE HELP, and THANK YOU in advance!

-Robert

AMAZING!!!

i seen some real geniuses on here and no one can seem to answer this, what I thought was an extremely simple question. it totally blows my mind. totally.

is xlsm format compatible with microsoft 2003? i have an xls file with macros but wanted to try out the newer file format of xlsm which supposedly is also macro enabled and has better security features. btw, xls format is for office 97-2003 and xlsm is a format that was introduced in office 2007.

Why isn't there a Sticky Thread giving examples of the most common questions and answers ? Or is there one that I can't find?

Like
How to eliminate NA from Vlookup?
How to count/sum multi criteria?
How to find last used cell?
How to lookup value in a matrix with Row and Column Variables?
How to Find Last X in Column/Row?

I'm trying to work on something that will allow me to do something if two results equal something...
so

If cell C4>499999 AND Cell C7=1, then multiply contents of cell C5 by .45
If cell C4>499999 and cell C7=2, then multiply contents of cell C5 by .55
If cell C4>499999 and cell C7=3, then multiply contents of cell C5 by .65
If cell C4>499999 and cell C7=4, then multiply contents of cell C5 by .85
If cell C4>499999 and cell C7=5, then multiply contents of cell C5 by 1.00
If cell C41, then multiply contents of cell C5 by .70
If cell C4

Haai Guys,

Maybe you can help me with the following,?

Sometimes when i leave a cell a messagebox pops up telling me "You must enter a number in this cell continue?" and then options YES, NO, CANCEL.
Is there a way to automaticly answer that question with YES and go on to the next cell?

I know why the popup comes up, that's not the issue, it should pop up when the daily users work with the sheet, only when i'm working with the sheet i would like a macro or something that auto answer the question with YES

Thanx a million

I'm trying to copy a sheet from one workbook, which creates a new workbook which is saved as book1.xls, and then copy that sheet over to the new book1.xls. I had no problem with this until I finished the whole code and that is when it started causing errors. Here's the portion of the code:

Code:

Sub CreateFinal()
Dim varPath As String
varPath = ThisWorkbook.Path

Dim varThatWorkbook As String
varThatWorkbook = "book1.xls"

ThisWorkbook.Activate
Sheet4.Copy
ActiveWorkbook.SaveAs varPath & "/" & "book1.xls"

Windows("book1.xls").Activate
Sheet1.Paste     THIS IS THE LINE THAT CAUSES PROBLEMS!!!!!!!

Dim varInput As Date
Dim Counter As Integer
 
varInput = InputBox("For what date is this report? MM/DD/YY")
 
Sheet1.Range("A100").Value = varInput

I'm a beginner with VBA and any assistance is appreciated!

Hi,

I am createing educational question/answer type programs using Excel. I have encountered two problems with this:

Firstly, I would like to know if it is possible to introduce a conditional helpful
picture or diagram into the sheet if a person being tested enters a wrong response, but no picture if a correct answer has been input. I am using IF statements, but I can't get them to "recognise" pictures or graphics.

Secondly, I would like to know if I can set the worksheet to allow input in certain cells only, but not in the rest of that worksheet. In other words, I am trying to create a sheet that scores as test subject's efforts, then can be reused by other people without it being accidentally changed or damaged by them.

Is there anyone who can please help me with this?

Thank you

I have an excel sheet that has the following.

Column A
Item Number

Column B
New Description

Column E
Item Number

Column F
Old Description


Column A and B contains just the items I'm needing. Columns E and F contains the information for an overall project, including things I don't need. An item number is flat out an Item Number. 1 in column A (wherever 1 may be) in reality is also 1 in column E, wherever that 1 may be, as well. The numbers don't match up left to right, though.

ie

1 NewDescription1 3 OldDescription3
3 NewDescription3 1 OldDescription1
5 NewDescription5 6 OldDescription6
6 NewDescription6 2 OldDescription2
2 NewDescription2 5 OldDescription5
*blank*-----------7 OldDescription7
*blank*-----------4 OldDescription4

SO, 1 NewDescription1 ties in with 1 OldDescription1

What I need is a a way to look at the Column A numbers, and find that same number in Column E, and post the Old Description of that number from Column F and put it in Column C.

Any ideas?

End result needs to be

1 NewDescription1 OldDescription1
3 NewDescription3 OldDescription3
5 NewDescription5 OldDescription5
6 NewDescription6 OldDescription6
2 NewDescription2 OldDescription2

In the end...it's a cross reference.

Actually, I bet it's easily answered. Nobody looked at my last post, so I had to try a new inviting subject line.

I use filters a lot to copy and delete rows of data.

I had no problems with any version pre-2007. It is hit and miss with 2007, but when I try and copy filtered data (or delete) it will usually copy (or delete) all the rows between the filtered data instead of JUST the filtered data.

Anyone know if there is a fix for this?

Thanks.

are there any if then formulas that will return blank cells?

thanks.