You are here:

Excel/Copy from one sheet to another if a condition is met

Advertisement


Question
Hello there!

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.

WORKSHEET A-          

COLUMN (L2:100) ONLY HOLDS VALUES: 0-30, "-", OR TEXT STRING "NO DUE DATE"


WORKSHEET B-

HEADINGS THAT NEED POPULATED FROM SHEET A:

DAYS UNTIL DUE, NAME, TITLE, ID

Answer
Hi Carri,

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
MediaFire:http://www.mediafire.com
FileFactory:http://www.filefactory.com
FileSavr:http://www.filesavr.com
FileDropper:http://www.filedropper.com
RapidShare:http://www.rapidshare.com
Box.Net:http://www.box.net/files

*Please be careful that it does not contain any PRIVATE & CONFIDENTIAL data (address, telephone, ID#s, etc.).


---

Sixthsense
About Excel
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

Excel

All Answers


Answers by Expert:


Ask Experts

Volunteer


Sixthsense

Expertise

[Overview] Having hands-on experience with Excel, I can able to answer questions which is related to Conditional Formatting, Goal Seek, Scenarios, Subtotal, Validation, Pivot Table, Shared Workbook, Excel Sheet / Workbook Protection, Excel Settings, Excel Shortcuts and the Two Major & Massive Key Areas of Excel (i.e.) Worksheet Functions and Excel VBA (Macro).

[Services] Volunteer in many of the Excel Discussion Groups / Forums and answered more than 10,000+ questions (approx.)

[Client FAQs] My Solution Files

[Not Interested In] Chart Questions

[Something Controversial]
*50% of answers never been read by the questioner's.
*Only 5% of questioner's provide feedback about the suggested answers.

Experience

Vast Experience

Education/Credentials
Ms-Office, Oracle, Foxpro, C, COBOL etc.,

©2016 About.com. All rights reserved.