Re: Importing data by JP
JP
Fri Mar 14 17:57:02 CDT 2008
You could save the first report, with comments, to a 'master workbook'
which you would use to add comments. When you run new reports, save
them to a different workbook and use VLOOKUP (either manually or by
code) to re-insert the comments back into the new report. Then you
could do a couple of things at this point:
1) Sort the data so the new entries (the ones that aren't in the
master workbook) are grouped together and then paste them into the
master workbook, where you would add new comments;
2) Use a macro to compare both worksheets and copy new rows from the
new report into the old report, where (again) you would manually add
new comments;
ps- what format are you using to import the data?
HTH,
JP
On Mar 14, 5:32=A0pm, Jen40 <Je...@discussions.microsoft.com> wrote:
> I am importing a report into Excel and I would like to make comments on ea=
ch
> line. But this report will change as I update purchase orders in our syste=
m.
> It will also change as purchase orders are received into our system. Our
> system generates this report and I would like the comments to stay with th=
e
> line when I import the new report that is different. I would like to make =
new
> comments on the new lines. Is this possible? if so, how?
>
> Item number =A0Purchase Order Date received =A0Name =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 Comment
> 11001 =A0 =A0 =A0 =A0 =A0 =A0102548 =A0 =A0 =A0 =A0 =A0 =A0 2/14/08 =A0 =
=A0 =A0 =A0 =A0Dell Computer =A0 =A0
> Waiting for invoice
> 12001 =A0 =A0 =A0 =A0 =A0 =A0152121 =A0 =A0 =A0 =A0 =A0 =A0 =A03/4/08 =A0 =
=A0 =A0 =A0 =A0 Lowe's =A0 =A0 =A0 =A0 =A0 =A0 =A0
> Cancelled order