How to append records to an excel worksheet and insert rows when necessary in Excel 2007
In my file I have a command button that filters information from a 'Sample' worksheet in excel and copies, performs a calculation, then pastes into a 'Data' worksheet in the same workbook. On the 'Data' worksheet, there is a header row on line 30. I need to know how I can insert more records on the 'Data' worksheet without overwriting the header row. Any ideas?
Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention. Check out this how-to article for more information.