Search results

You might be interested in this: =COUNTIF('Mar 10'!AD5:AD65536,"No*") Since each of the cells you want to count start swith the word 'No', the above will also return a result of 4. The asterisk is a wildcard, allowing any combination of characters after the 'No'. Just thought you may like...

Hi If you need to reference a cell on another sheet, you can refer to that cell by prefixing the cell label with the sheet name. For example, Excel, by default names its worksheets as Sheet1, sheet2, sheet3, etc. If you are working on sheet2 and need to reference a cell on sheet 1, lets say...

Hi Following on from the previous post, you can remove the attribute from all files in the directory and all sub-directories by using: attrib -r *.* /s This can be used inside a batch file or at the command prompt.

Hi It's very similar to your previous post, but have you tried: start excel "file 1" "file 2" "file 3".....

Hi I can see an arguement for both sides of this discussion, but ultimately, I think that which ever method you employ in your application, users (even those who oppose your final decision) will very quickly get used to it. What happens if, in a busy environment, something (not too heavy)...

Hi What you are looking for is possible with any relational database. Access, for example, would allow you to set up simple queries that could return all records that matched whatever criteria you entered. You could also set up filtering options to show you only the records you are looking...

Hi I came across an interesting scenario that one of my colleagues had encountered. She had a document in which she needed to remove a number (thousands) of excess spaces in a large table that spanned many pages. The only solution we could come up with was to replace all the spaces with...

Hi If the original columns are formatted as text in order to keep any number of leading zeros and the cell in which you want the result is left with a general format, then the following will work: =CONCATENATE(B2, " ", C2, " ", D2, " ", E2, " ", F2) See attached example.

Hi I think I have found a resolution to the problem in that I created a new blank database and imported the tables from the BE and the Forms, VBA, Reports, etc. from the FE database. I then split this new database and (so far) everyone seems to be able to access it. I still don't know why...

Hi David We do not use roaming profiles, so if we log on to each others PCs, we don't see anything. Perhaps this points to an issue on the other users PC? I just can't see what it is. We are both members of the local administrators group on our PCs, albeit that I have been set up as a user...

Hi BrettM Thank you for your assistance The network share is on one of our Windows fileservers, we have a client/server network set-up. All of our PCs have the same mapped drive to the network share and all users have the same the security/access rights in the shared drive. The BE database...

Hi there I have created a split database (back end is on a shared network drive and front end is on users' PCs) and it seems to work well on all but one of the PCs, where the user gets the following error: The user has local administration rights on the PC, the front end database is located...