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!

Register Log in
  • Congratulations Chriss Miller 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 darkdestroyer1980

  1. darkdestroyer1980

    Column advice totalling data on criteria

    Hi, I need some general pointers on a couple of Excel macros that I'm trying to write. I have several columns of long data such as below: a 65,395,297 b 32,180,320 n -36,603,762 o -37,355,582 p 71,138,303 q -78,920,800 r 220,522,039 -236,329,886 a1 -3,983,788 a2 -33,132,163 a5...
  2. darkdestroyer1980

    view containing folder when searching

    Hi, Is it possible to search in outlook and under the search results to identify which folder(s) particular emails belong to? Thx
  3. darkdestroyer1980

    Excel

    Hi, I had two excel files open and Excel crashed. File a was around 3mb, b was 512k. Now file A seems to have been over written with most of the data from b, it's around 530k. When I go to open the file I get "File not found", followed by "Excel found unreadable content in A.xls" It then asks...
  4. darkdestroyer1980

    automate moving folders in outlook

    thanks smah, rule is working a treat, been going strong for past 2 hrs
  5. darkdestroyer1980

    automate moving folders in outlook

    Hi, is it possible to move existing emails within the the inbox to a sub folder automatically? currently the inbox has around 125,000 items. The mailbox is around 4gb, over a slow connection this is painful. I can't move items in bulk as it times out, so I'm having to manually move over half a...
  6. darkdestroyer1980

    Excel graph with two y axis

    Hi, I've got a line graph that shows two trends, both trends break go thru the x axis. I'd like to add another scale on the right hand side for y axis, but don't know how to do this within Excel. Any ideas much appreciated. Thx
  7. darkdestroyer1980

    outlook 2003 calendar

    Hi, I have an outlook calendar called oxfordoffice and a a contact list by the same name. I'm trying to view the oxfordoffice in a split window view alongside my own calendar, but whenever I use the open a shared calendar option I only see the contact list in the dialog box - no option for...
  8. darkdestroyer1980

    Excel cell inconsistencies

    thx gavin, now works, they had different folders mapped on the same drive
  9. darkdestroyer1980

    Excel cell inconsistencies

    Hi, I have an excel file on a network drive, my colleague has the file open, so when I open I get a read only copy. As soon as I open it, I get a prompt to update/dont update links, what I notice is that as soon as I click either option some of the cell values change. I've tried changing...
  10. darkdestroyer1980

    vba - sum based on cell values

    thx, pivot table worked a treat
  11. darkdestroyer1980

    vba - sum based on cell values

    Hi, I have an Excel spreadsheet in the format below. I'd like to write a formula that can calculate the trader commission total, as well as the broker commission within each trader. Essentially, it'll add the commission columns for each value relating to trader1 to give an accumulative. It...
  12. darkdestroyer1980

    Email body collapsed when forwarding or replying

    Hi, I have an email from person A, sent to B, sent to me. The email is in html format and so is my mail client, when I hit reply, reply to all or forward it shows only part of the email, it's as tho all the html is stripped and the entire body (previously a few pages) collapsed into a few...
See more

Part and Inventory Search

Back
Top