In the attached sheet "PROBLEM" it has two tabs. "Data" & "Working"
The Data tab gets deleted and replaced almost daily. The working tab is the format to use to handle calculations. When the Data worksheet is imported I would need VBA code to loop through the data one row at a time and split the cell value from being X/X to two cells in the "Working" worksheet.
The primary key field is a unique value.
Cell Y4 on the data worksheet would need to be split into cells AH6 and AJ6 on the working worksheet. And so on through the cells, then the next row.
I have tried formulas but loose everything every time I delete and re-import a new Data worksheet.
Some help here would be appreciated.