Hello!
I am trying to see if there is a way to achieve my idea without nesting IF AND/IF OR statements in the formula bar. I am not too familiar with VBA, but I imagine there is some code that could help me with the following goal:
I am creating an excel workbook database that will allow users to enter a document number in cell B3 and a material number in B6 on the "Autofill" sheet (Sheet1). There is a separate corresponding sheet in the workbook for each possible document number that can be entered in B3. On each of those sheets there are lines of information that correspond with each material value that can be entered in B6.
I would like to code a simple command button that will copy that line or lines onto line 11 of "Autofill" sheet based on the values entered in B3 and B6. So each time new numbers are entered, new information replaces line 11.
Anyone able to help? It would be MUCH appreciated
I am trying to see if there is a way to achieve my idea without nesting IF AND/IF OR statements in the formula bar. I am not too familiar with VBA, but I imagine there is some code that could help me with the following goal:
I am creating an excel workbook database that will allow users to enter a document number in cell B3 and a material number in B6 on the "Autofill" sheet (Sheet1). There is a separate corresponding sheet in the workbook for each possible document number that can be entered in B3. On each of those sheets there are lines of information that correspond with each material value that can be entered in B6.
I would like to code a simple command button that will copy that line or lines onto line 11 of "Autofill" sheet based on the values entered in B3 and B6. So each time new numbers are entered, new information replaces line 11.
Anyone able to help? It would be MUCH appreciated