theta
12-13-2011, 08:57 AM
Hi all...I was hoping to get some help on a small problem
I have a sheet (say A:G) that contains data from a file. In the adjacent columns the user can input information (say H:L).
The data in columns A:G needs to be updated from a report (which can grow massively in one day) but I need to ensure I retain the data from H:L as this is manually entered.
I would like a macro to import a file (CSV) into sheet "DATA", and also pull it into an array or collection > then using an reference built from the first 3 columns (client, partner, period) lookup the data already existing in H:L.
The completed array / collection can then be pasted as values back over A:L on the original sheet.
How can I load the imported file into an array, then build a reference and lookup the data already in H:L? Then dump it all back into the sheet A:L
Any help appreciated :)
1. All current data is contained in "Sheet1"
2. Import new file into "DATA"
3. Load into an array
4. Build references
5. Lookup data from "Sheet1" H:L
6. Overwrite all information in "Sheet1"
Or if you can think of a better method I will gladly listen :)
I have a sheet (say A:G) that contains data from a file. In the adjacent columns the user can input information (say H:L).
The data in columns A:G needs to be updated from a report (which can grow massively in one day) but I need to ensure I retain the data from H:L as this is manually entered.
I would like a macro to import a file (CSV) into sheet "DATA", and also pull it into an array or collection > then using an reference built from the first 3 columns (client, partner, period) lookup the data already existing in H:L.
The completed array / collection can then be pasted as values back over A:L on the original sheet.
How can I load the imported file into an array, then build a reference and lookup the data already in H:L? Then dump it all back into the sheet A:L
Any help appreciated :)
1. All current data is contained in "Sheet1"
2. Import new file into "DATA"
3. Load into an array
4. Build references
5. Lookup data from "Sheet1" H:L
6. Overwrite all information in "Sheet1"
Or if you can think of a better method I will gladly listen :)