RAYLWARD102
Well-known Member
- Joined
- May 27, 2010
- Messages
- 529
I have a macro that imports data from a csv type file. It imports the data into a sheet named dump. After import; I have another macro that inserts a blank row after every row of data. I've done this because there are two sheets that refrence the cell values from dump and the cells in these two other sheets have all merged cells. When I tried to fill a formual down in these 2 sheets; it was automatically doing it based on odd numbers because of the merged cells; hence the reason why I had to add the blank row after every row of data in the dump sheet. After completing the formulas to work the way I wanted' I saved the workbook. IF I delete the dump data and re-start the import process; the formulas on the 2 refrence sheets change. They suddenly change to look at even numbered cells in the formulas. Does anyone no how I can stop this? I can't have the formulas changing. This is confusing! I also tried protecting the sheet. The formulas still changed!