Search results for query: *

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

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

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

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

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

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

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

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

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

thx, pivot table worked a treat

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

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