Recent content by pjmdesigns

Der, Used Ctrl and down arrow as you suggested - fantastic! Cheers Gavin!

Cheers Gavin, almost perfect, I have everything on one sheet at the moment and it copies across nicely. I have a button at the top of the sheet to run the macro but at present it is hard coded to start at cell C3, ideally I would like either: 1) It to locate the next empty cell in column C OR...

Thanks for the response, I ran this and it returns the text after the comma per cell, excellent! Problem is though that it only does this if there is text after the comma or it falls over, as on occasion there is no text after the comma (pre-comma per cell is the question, post is the answer...

Apologies, I didn’t say in my request that I am not familiar with VB, I have just created a key-stroke macro on sheet1 using text to columns, but this does not account for the possibility of additional commas, beyond that I have not moved to sheet 2, I have fond scripts to make columns into rows...

I have a workbook with two sheets. I intend to use sheet1 to paste a COLUMN of data into column ‘A’; this will always populate 74 rows, formatted as follows: First Name, Paul Last Name, John Address 1, 5, Newton Close Address 2, Walthamstow ...and so on On sheet2 I have a row of headers from...

I am setting up a Small Business network of 8 PCs which is likely to grow to 10 max, this is currently peer to peer but at the weekend will have a dedicated server running SBS, with all client PCs sharing the server's internet connection. The thing I am having trouble with at the moment is...

Hi I hope someone can help? I have created a very simple site in Frontpage, effectively a procedure guide for our staff; this will only be used internally with a link on each user's desktop to the index.htm file on our server. What I need to do is add some sort of Message Board; I want...

I must be honest I didn't even know DATA / SUBTOTAL existed, it is almost what I want but the format isn't too good. SUMIF sounds promising; I'll give it a try. Thanks.

Hi I have a table of data which is about 6,000 rows deep; by way of an example this might contain the following: Employee Monthly Bonus otherdata1 otherdata2 etc 111 1,000 111 1,500 111 1,254 254 5,254 254 6,854 122 1,111...

Thanks to you all, I tried everything suggested but unfortunately to no avail, if nothing else I learned a few things :) Ended up with a reinstall and all is now fine. Thanks again.

Hi All, apologies for not getting back sooner! Starting from the top: (1) The system does exactly the same thing in Safe Mode, no matter which 'Safe Mode' I select, i.e. with Network support etc. (2) As amen1973 stated, I was trying to run tasks from the Taskmanager. I have now visited...

I tried this, but gave it another go just now as well, no joy!! I am just downloading a Boot disk, hopefully there is some sort of repair utility.

Hi, hope someone can help! I'm Going Crazy here! We have a PC on our Network running XP Pro, when you boot the PC it seems fine, however once you have logged into Windows all you get is the Wallpaper, absolutely nothing else, the right click on the mouse does not work, all you can do is...

Hi All, hope someone can help, I am running XP Home on my home PC (sorry nothing for this on tek-tips!), the PC has two Administrative users set up, and i have just created a third user with restricted access, the thing is when I log in as the new user I keep getting a dialog box appearing...

So simple it's genius! Thanks to you both for the ideas. Sorted! I created 4 headers A, B, C, D, all A4 page height and repeated the Invoice 4 times, so the 'footer' is effectively different at the bottom of each header! Thanks again PJ.