Lookup Column, paste result of table in correct Row

07-02-2003, 08:13 AM

Jax

Newcomer

Join Date: Mar 2003

Posts: 2

Excel97 Lookup Column, paste result of table in correct Row

I have a Lookup table that holds information gathered from an Excel Add-in (PiDas) this requires a date-stamp and once the date is changed the information is lost. What I want to do is copy the info from the table and Paste values into another worksheet (this worksheet has dates and other info already) into the same row as the date it relates to, this keeps the info and cuts the Pidas Link?! then I'd be able to save the info

Unfortunately I haven't been able to figure out how to select the matching Row from the Column with the dates

Last edited by Jax; 07-02-2003 at 08:22 AM.

07-06-2003, 02:14 PM

eb88295

Regular

Join Date: Jun 2003

Location: Indianapolis, IN USA

Posts: 68

Find

Need more to go on. You might play with the Find statement.

07-18-2003, 03:56 AM

Jax

Newcomer

Join Date: Mar 2003

Posts: 2

Thanks freshman,
Figured this out with lots a help

using evaluate to lookup and then match the column and row eg.,
LookedUpItem = Evaluate("VLookup(--(yPiDasData!C1 + yPiDasData!D1), yPiDasData!C1:F14, 3, 0)")
Debug.Print LookedUpItem
cRow = Evaluate("match(yPiDasData!B2,MidNightDatabase!B1:B14,0)")
Debug.Print cRow
CColumn = Evaluate("match(yPiDasData!D1,MidNightDatabase!D2:G2,0)") + 2 + 5
Debug.Print CColumn
Sheets("MidNightDatabase").Cells(cRow, CColumn) = LookedUpItem
Regards Jax

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is Off HTML code is Off Forum Rules

Forum Jump

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Determine pivot table size	dawookie	Excel	2	07-01-2003 05:08 PM
Column formatting with make table query	baclay	Database and Reporting	0	10-15-2001 08:03 AM
Pausing VBA after a Shell Command	matt_wendling	Word, PowerPoint, Outlook, and Other Office Products	10	10-10-2001 09:07 AM
How do you insert a new column to a specifc place in the table?	jamesmuglia	General	1	06-28-2001 02:17 PM
VB Help	jdn6705	General	4	02-27-2001 01:50 PM