Hi all,
(newbie Forum Member here)
Hoping to get some help with a problem I'm having.
I have a new laboaratory instrument that puts out test results in *.csv format. I created an excel template with a summary report format on one tab within the workbook, with the intention of having this workbook be a blank template (e.g., operator opens the file template, does a "save as..." new file name and then steps through the process for getting the instrument's *.csv data imported. Post data importing, I want to have the template report out Key data/information needed from the imported file(s).
I predetermined (mapped out) which cell references I needed to extract the values I want (from the intrument's standardized *.csv file output), I setup several tabs for importing data into for each new test condition; I then created a summary report tab and wrote the formulas to go get values from each of the import data tabs, referencing what should be 'fixed' cell references to get the data needed.
To summarize, I want to be able to extract key data/information from this (instrument output) data so as to be able to report out results in a more concise/comprehensive manner to be able to give to my customers. The problem is, when I actually IMPORT the *.csv file data my 'fixed' cell references are obliterated (changed to #REF! post-importing the dataset).
EXAMPLE: The formula reference "COND_01" is the name of the worksheet where I intend to import the first condition's (*.cvs file) test results.
=IF(COND_01!$B$6="","",COND_01!!$B$6) ...post-importing any given *.csv file import into tab COND_01 the formula changed to =IF(COND_01!#REF="","",COND_01!!#REF)
Any suggestions on how I can get this to work?
Thanks,
Michele
P.S. I have no problems in import this "From Text" data into a separate (pre labeled) tab within an excel spreadsheet (template) I created.
I click on the tab where I want to import the test data into and click on the first cell A1. Then, I go to the Data tab on the menu bar; select Get External Data option and From Text and then I select the *.csv file I want and hit the Import button. I leave the Import Wizard's default settings it opens with as "Delimited", the Start import at row "1", file origin is "65001 : Unicode (UTF-8)"; and click the Next button; in the next window, I change the delimiters from Tab to Comma, and click the Next button; I leave the Column data format as "General" and click the Finish button; and click OK to confirm that I want the data to be put into the existing worksheet I've selected and starting at $A$1 cell.
Bookmarks