Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. KiwiRiccardo

    Worksheet_Change Macro will not finish running

    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...
  2. KiwiRiccardo

    Excel Sorting Blank Cells as if they have a Value

    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...
  3. KiwiRiccardo

    Does Excel 2000 not record "Save as" when recording a macro

    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...
  4. KiwiRiccardo

    Excel - Separating data into worksheets based on a column value

    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...
  5. KiwiRiccardo

    Excel - Conditional results -

    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...

Part and Inventory Search

Back
Top