Excel/Copy from one sheet to another if a condition is met
I have a worksheet where I need to look up and match number range between 0-30 from only the one column in Worksheet A, about that one instance, then the next etc.. then auto populate same number rows (where every is match found) with corresponding numbers and also populate adjacent cells into rows in Worksheet B with corresponding data.I think I need to use a count function first, then array, then Vlookup but I am somewhat a bit of a beginner assigned to this task without tools to accomplish it. The program I'm using on the job is Excel 2003 and the VB is not functioning and needs to be re-installed to fix, unfortunately disk is forgotten and owners not willing to secure newer version. So, without a macro I have to use functions only to create the outcome. Thank you for your assistance.
COLUMN (L2:100) ONLY HOLDS VALUES: 0-30, "-", OR TEXT STRING "NO DUE DATE"
HEADINGS THAT NEED POPULATED FROM SHEET A:
DAYS UNTIL DUE, NAME, TITLE, ID
Thanks for sending your question on my way and request you to attach a sample workbook in somewhere in the web by covering the expected output and send me the download link.
Windows Live Skydrive:http://skydrive.live.com
*Please be careful that it does not contain any PRIVATE & CONFIDENTIAL data (address, telephone, ID#s, etc.).
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here