![]() |
|
Excel boffins - Printable Version +- WBAUnofficial (https://wbaunofficial.org.uk) +-- Forum: WBAUnofficial (https://wbaunofficial.org.uk/forumdisplay.php?fid=3) +--- Forum: WBAUnofficial (https://wbaunofficial.org.uk/forumdisplay.php?fid=4) +--- Thread: Excel boffins (/showthread.php?tid=13826) |
RE: Excel boffins - Birdman1811 - 11-23-2020 Sorry just need to do this. STOP USING EXCEL AS A DATABSE! There I feel better. RE: Excel boffins - MassDebater - 11-23-2020 Sounds like you need to write some VBA to pull in the list of the other sheets at the right times... you could write the names in one sheet, get the VBA to loop through them and pull the info you need into the other one... Regarding getting them into Access, it's piss easy... in the newer versions once you've set the basic database up just go into External data and tell it to link to the Excel sheets that you need, that way if anyone changes anything in the Excel sheets the Access db will still be updated with their changes too.... You'll end up with a database with however many tables you have though, rather than one table that pulls info from them, but you could then set something up to pull the info from them into a new central table... Time consuming and boring as hell though! Better (as you know) is one table that everyone accesses and updates as needed, in a proper database. I fucking hate it when people try and do database stuff in Excel...worse is the maths stuff some do in Word etc... grrr!! |