Screenupdating vba msdn
Sounds to me like you may actually want to include ALL possible cells in your range, then loop through each cell in your range to see if it is blank or not, and then deciding what to do based on that fact. Use the built-in Help that comes with Excel/Access 2. A lot of VBA code can be acquired by using the Macro Recorder. To be able to do some analysis on all the data I want to pull the data from all sheet1s together in one spot.If you need help with that, can you explain in English exactly what you want to happen (rather than trying to guess what you want to do by trying to decipher your code, especially if it is not working properly)? That macro I found does this but it also copies all the blank cells.
It runs on a protected worksheet, and works with most dependent drop down lists. Actually it pulls only the info (so starting in A2). Currently, the rest would get pulled exactly like above (with all the blank cells) just plus one column (column A) to add the file name. However, if all your files are structured the exact same way, i.e. This is no problem though, since I can just add the first row afterwards. Company Name is always in E1, File Number is always in C3, etc, then I think this is doable. Use the built-in Help that comes with Excel/Access 2. A lot of VBA code can be acquired by using the Macro Recorder. There are tools mentioned in section B here that tell you how you can post screen images: FOR FINDING EXCEL SOLUTIONS 1. " This is what the beginning of the original file looks like. -- removed inline image --- The goal is to pull the data out to have something like this. In truth there are a lot of merged cells and it looks a lot cleaner to the eye. The content is always in the same cell, so that is a constant I can depend on.