ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Export only Modified Records (https://www.excelbanter.com/excel-programming/423985-export-only-modified-records.html)

yovation

Export only Modified Records
 
Hello,

I have a .txt file with 17,000 records. When I update/modify one or
two records, I would like to export the updated/modified records into
a new .txt file that i can upload to my online store.

Is that possible?

What I am trying to accomplish is keeping an offline database of
inventory I have in my online store. There is no need to update the
entire .txt file if I only need to change one or two records. Perhaps
there is an easier way. I don't want to 'link' to the online file. I
want the data I am working on completely off line.

thank you.
David

Don Guillett

Export only Modified Records
 

You could use a worksheet_change event that copies that row to a new sheet
next available row and then save that sheet
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"yovation" wrote in message
...
Hello,

I have a .txt file with 17,000 records. When I update/modify one or
two records, I would like to export the updated/modified records into
a new .txt file that i can upload to my online store.

Is that possible?

What I am trying to accomplish is keeping an offline database of
inventory I have in my online store. There is no need to update the
entire .txt file if I only need to change one or two records. Perhaps
there is an easier way. I don't want to 'link' to the online file. I
want the data I am working on completely off line.

thank you.
David




All times are GMT +1. The time now is 10:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com