Hi all, got a question but it is a bit difficult to explain. Here goes (excel 97):
Sometimes either formulas, cut (or copy) and paste, or inserted rows or columns result in data (or something) in the row or column all the way to the end of the sheet (apx row 64,000, or column zz or something like that). The only way I am able to break the needed cells out is to copy and paste into a new spreadsheet. Is there some command to prevent this from occuring or to blank out everything but the ‘normal’ data fields?
That is my main question, have one more but it isn’t that important. I have to add data from one spreadsheet to another. At this time I am bringing both into Access to link the data then exporting them back to Excel. Is there a way to do it all from Excel? If so is it better?