On my soreadsheet I want to fill in the other worksheets depend on the criteria entered on the 1st sheet (Entrants). the problem I have is that although it is working, gaps get left, I want to fill from the top. I have attached my spreadsheet. Many thanks
Filling in Workisheets from the Top
- Thread starter ddrew
- Start date
Trevor G
Registered User.
- Local time
- Today, 17:46
- Joined
- Oct 1, 2009
- Messages
- 2,367
The only way I see this giving you what you want in Excel is via VBA, or place this in a Access Database as you can manage everything in a table and then query the relevant fields and you will have a continous report you can look at as an when which gives you a true snapshot of the data and results
