Search results for query: *

Skip, That is great, thank you for your help. Rich

All, I don't often have to use VBA so don't really know what I am doing however I seem to have come up with some code that works other than just continues to run. I can sort of see why it does this but was wondering if anyone could give me a point in the right direction. The code enters a...

Actually I have just completed my macro and looked at the code and infact we are replacing the "#N/A" with a "" (see below) and yet I can now sort my "visible" data as I would expect to be able to. Seems a bit odd but no doubt there is an answer. Ric Cells.Replace What:="#N/A"...

Thank you that has worked well. I have used a find and replace to delete all of the #N/A's and this seems to have done the trick so I can now sort my data at will. Cheers Richard 30 degrees in London today!!

Hi all, hope that someone can help with this before my laptop takes the short way from the 9th floor;-) Right I have a workbook called "Central Data" with 2 worksheets lets call them "Linked Data" and "Text Values" "Linked Data" is sectioned into groups of 100 rows that link to other workbooks...

Hey check out my thread just below, "Seperating data into worksheets based on a column value. This by the looks of it is a very similar problem. Cheers Kiwi

Does seem strange it working in XP. Could someone with 2000 please do a little testing 4 me? Would be very grateful for this info. Thanks

Thank you all for your excellent input. Cheers Kiwi

I hope an easy question to answer. We have just been upgraded to Excel 2000 at work and I have noticed that when including a save or save as in a macro this is not recored. The code is simply missing when editing the macro but it the code is manuall added it seems to work okay. Is this a...

rdodge, Excellent, I will give this a hack and post an update next week. Thanks. 5.30pm and beer o'clock. Thanks for the replies Skip

English east end slang. "Pukka" = the best, excellent, great etc... Think I have been in England too long.

I can be sure that I will not have any more that a few hundred rows in each team sheet so if a formula was down to the 1000th row (for example) this would resolve. Agree totally that a pivot table would produce the info, but is will not produce the 100% pukka result I was hoping for.

The reason is simply that is what the business have requested the data in that format. Going forward I do not want to get involved in the production of this report so I am trying to automate the process. I was hoping that there might be a formula that could be used that would select rows...

Skip, I think the data table is okay. I had thought of using a pivot table using "Team" and then expanding the totals of the pivot table to create the sepatate sheets. I do want to automate the process with a macro as I will not be the end user but I do not think that this will...

There might be another way of going about this but I am having a mental block. I have a worksheet that contains data for five teams. The team is indicated by a column in the worksheet. What I need to do is sepatate out and group each team data onto individual worksheets within the workbook...

bluedragon2, SkipVought, ETID, Thanks for your help on this one. So easy when you know how!!

Right, what I am trying to do is this. Data is already in Excel. I have 30 users that each process transactions that have their user name attached. each user belongs to one of five teams. I need a new column that shows the team that a user belongs to based on their name. I have been...