Question
-
Topic
-
Excel Macro Question
LockedI need to write a macro in Excel. I have an existing spreadsheet with data. I am importing in to a 2nd sheet a CSV file containing a list of data with basically an ID field and a quantity field. I want to take the ID field, and search to find a match on the original Excel sheet, and when I find it, take the number in the quantity field of the imported data and update the corresponding quantity field in the original sheet. The importaed data is variable, so it will different each time it’s imported in, so I’m not searching for the exact same data each time, if that makes any sense. Is there an easy way to do this? Thanks.
All Answers
Viewing 1 reply thread