Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / March 2008

Tip: Looking for answers? Try searching our database.

Importing data

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jen40 - 14 Mar 2008 22:32 GMT
I am importing a report into Excel and I would like to make comments on each
line. But this report will change as I update purchase orders in our system.
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 the
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  Purchase Order Date received  Name                 Comment
11001            102548             2/14/08          Dell Computer    
Waiting for invoice
12001            152121              3/4/08           Lowe's              
Cancelled order
JP - 14 Mar 2008 23:57 GMT
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

> I am importing a report into Excel and I would like to make comments on each
> line. But this report will change as I update purchase orders in our system.
[quoted text clipped - 8 lines]
> 12001            152121              3/4/08           Lowe's              
> Cancelled order
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.