Okay, I was planning to do something in this project that I'm working on that I thought would be fairly straightforward. It is similar to something I do in Word all the time without code. But heck if I can figure it out! I don't know if I just don't know what to call what I'm trying to do, so I can't find it in any of my reference books, or if it is maybe just one of those things I'm going to have to do through VBA. Here's the scenario. Hopefully, someone can set me straight:
The workbook has many sheets. On a number of them, the first six columns of data needs to be the same, with additional columns of data on each sheet reflecting the purpose of that sheet. But the information is not static. Users may add, insert, or delete rows on the primary sheet and all the subsequent sheets will need to be updated to reflect the changes, sort of like cascading updates and deletes in Access. Right now, I have the first five columns of the first 150 rows (hopefully more than enough) on the "second" sheet filled with a formula something like this:
That works fine for the existing data, and anything added at the end up to row 150. But inserted and deleted data just updates the formula to refer to the corresponding +/- rows as appropriate (which, under other circumstances, is probably exactly what I'd want it to do). Am I missing some way to refer to a range or sheet that creates this type of interdependence? Or is this something that calls for VBA? And, if it is VBA, and there's a sample of something similar around somewhere, a link to that information would be greatly appreciated. I've attached a sample file. Many thanks!
By the way, I think I am probably using SP-1. The LAN admin. blew up my computer a couple weeks ago while I was gone for the day, and he had to reformat the hard drive and reinstall everything. I'm pretty sure he didn't install any service packs, and I haven't had time myselff, yet.