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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by password

  1. password

    delete orpaned user from Active directory

    simply , the account doesn't appear in active directory users and copmuter , but appear in global address list in exchange and when a make search in active directory
  2. password

    delete orpaned user from Active directory

    Hi all , i have restored DC after disaster , the domain dom1 is empty except ABC user , after restoration i found that a user account appears when i make search in active ditectory , using active directory search , if i search in each domain this user does not appear , when i try to delete...
  3. password

    Sending Emails to nested groups prblems

    Dear All ; Can you help me to solve this problem in exchange 2000 Messaging systems . Environment description : Active directory with tow domains , Acorp (root)and Bcorp Exchange Server is joined to Bcorp domain. All domain controllers are in the same site . FSMO and global catalog servers...
  4. password

    problem when Sending message to groups in exchange 2000

    Dear All ; Can you help me to solve this problem in exchange 2000 Messaging systems . Environment description : Active directory with tow domains , Acorp (root)and Bcorp Exchange Server is joined to Bcorp domain. All domain controllers are in the same site . FSMO and global catalog servers...
  5. password

    Enterprise Backup system software coparison

    thank you ,but i need to convence my CIO by competitive study,do you have?
  6. password

    Enterprise Backup system software coparison

    Dear All : greeting i'm planning for enterprize backup system for my corporate , i have more that 1TB daily backup ,and i want to evalute the current backup software such as ARCServe, Veritas ..etc , to choose one of them . any one have a new coparison study , a mong backup sotware will be...
  7. password

    Problem refreshing pivot in seperate worksheet

    PH Frustrating, but correct. Thanks for the pointer. Regards Nick
  8. password

    Problem refreshing pivot in seperate worksheet

    Hi "Which code?" is a another question I need answering but I was trying. WorkSheet("Sheet2").Activate ActiveWorksheet.RefreshAll Just tried your Application.Calculate suggestion but pivots did not refresh. Nick
  9. password

    Problem refreshing pivot in seperate worksheet

    Hi "Which code?" is a another question I need answering but I was trying. WorkSheet("Sheet2").Activate ActiveWorksheet.RefreshAll Just tried your Application.Calculate suggestion but pivots did not refresh. Nick
  10. password

    Problem refreshing pivot in seperate worksheet

    Hi I have some code running under the Worksheet_Change function in object Sheet1 in a workbook. This code updates cells in sheet1 when data is pasted into sheet1. This works fine. As a result of changes to sheet1 (occuring when user pastes data) I want the Pivot tables in sheet2 to refresh...
  11. password

    VB to copy/delete formulas based upon last row of data

    Skip Apologies, I was not being clear. First time the user uses file he opens and the query, gets the data, and the formulas automatically fill to the row number of the data paste - perfect. Next month user opens file again. The query updates but it has less rows than previous month = excess...
  12. password

    VB to copy/delete formulas based upon last row of data

    Skip Don't understand your last comment. First time the user uses file he opens and the query gets the data and fills the formula the - perfect. Next month user opens file again. The query updates but it has less rows than previous month = excess forula rows (generated from previous months'...
  13. password

    VB to copy/delete formulas based upon last row of data

    Hi have got it to work, thanks. This is a useful technique. However 1) there is the problem with the add-in 2) solution does not delete 'excess' formula rows. Part 2 is my main issue as the number of formula rows (and the resulting size of the ranges) are having a big impact upon speed and...
  14. password

    VB to copy/delete formulas based upon last row of data

    Skip Am just running through this and I hit what I think could be my first hurdle. Miscrosoft query was not installed for me (though it now has). Users will freak if they see the same issue. Will anyhow update you when I've got this to work... N
  15. password

    VB to copy/delete formulas based upon last row of data

    Skip A-SalesCo B-SalesBrand 1 C-Mill D-G/M2 E-Cal.year / month F-MonthOrigInv G-Curr H-Tons I-Turnover Value J-Turnover Value Main Curr K is an empty column L-months M-string1 N-string2 O-curr string1 P-curr string2 Q-tons R-EUR value S-curr value T-gsmtons These headers in ROW2 (but no reason...

Part and Inventory Search

Back
Top