Ok, I have a workbook that has these columns:
category, line, status, carrier, billing, circuit, type, use, from, to, comments, budget, YTD spending, projected YE, variance, billing code (whew)
on another workbook in the same spreadsheet, I put a drop down with data validation to select the line (second column in the data on the other page).
upon selection, and clicking a button, I would like it to retreve the entire row that contains that line id...
for example... I select LI-43 from the drop down, click the button and below would see
ION (category), LI-43 (line), Active (Status), etc.
the page withall the data is the range starting at A4 thru P400 on a sheet named "master all lines".
I want the data to be displayed on a sheet named "Make Inactive" in row A15
Any help would be greatly appreciated!!!
Bookmarks