Search Results

Search found 26896 results on 1076 pages for 'microsoft account'.

Page 156/1076 | < Previous Page | 152 153 154 155 156 157 158 159 160 161 162 163  | Next Page >

• How do I create a VBA macro that will copy data from an entry sheet, into a summary sheet by date

  - by Mukkman

  I'm trying to create a macro that will copy data from a data entry sheet into a summary sheet. The entry sheet is going to be cleared daily so I can't use a formula just to reference it. I want the user to be able to enter a date, run a macro, and have the macro copy the data from the entry sheet into the cells for the corresponding date on the summary sheet. I've looked around and found bits and pieces of how to do this but I can't put it all together. Update: Thanks to the information below I was able to find some additional data. I have a pretty crude macro that works if the user manually selects the correct cell. Now I just need to figure out how to automatically select the current cell relative to the current date. Sub Update_Deposits() ' ' Update_Deposits Macro ' Dim selectedDate As String Dim rangeFound As Range selectedDate = Sheets("Summary Sheet").Range("F3") Set rangeFound = Sheets("Deposits").Cells.Find(CDate(selectedDate)) Dim Total1 As Double Dim Total2 As Double Dim Total3 As Double Dim Total4 As Double Dim Total5 As Double Total1 = Sheets("Summary Sheet").Range("E6") Total2 = Sheets("Summary Sheet").Range("E7") Total3 = Sheets("Summary Sheet").Range("E8") Total4 = Sheets("Summary Sheet").Range("E9") Total5 = Sheets("Summary Sheet").Range("E10") If Not (rangeFound Is Nothing) Then rangeFound.Offset(0, 2) = Total1 rangeFound.Offset(0, 3) = Total2 rangeFound.Offset(0, 4) = Total3 rangeFound.Offset(0, 6) = Total4 rangeFound.Offset(0, 7) = Total5 End If ' End Sub This version will find the first value on the page and fill in values: Sub Update_Deposits() ' ' Update_Deposits Macro ' Dim selectedDate As String Dim rangeFound As Range selectedDate = Sheets("Summary Sheet").Range("F3") Set rangeFound = Sheets("Deposits").Cells.Find(CDate(selectedDate)) Dim Total1 As Double Dim Total2 As Double Dim Total3 As Double Dim Total4 As Double Dim Total5 As Double Total1 = Sheets("Summary Sheet").Range("E6") Total2 = Sheets("Summary Sheet").Range("E7") Total3 = Sheets("Summary Sheet").Range("E8") Total4 = Sheets("Summary Sheet").Range("E9") Total5 = Sheets("Summary Sheet").Range("E10") If Not (rangeFound Is Nothing) Then rangeFound.Offset(0, 2) = Total1 rangeFound.Offset(0, 3) = Total2 rangeFound.Offset(0, 4) = Total3 rangeFound.Offset(0, 6) = Total4 rangeFound.Offset(0, 7) = Total5 End If ' End Sub

  Read the article

• Apply SharePoint template to existing site?

  - by johnnyb10

  I have several similar SharePoint sites (running on WSS 3) and I have saved one of the sites as a template. I now want to make a different site (which already exists) have the same structure as this site--the same lists, document libraries, views, etc. I know I can delete the existing site and then recreate it based on this template, but is there a way to apply this template to my existing site, so that it gets rid of its existing lists, etc., and replaces them with the ones from the template? I don't have any content in the site, and I don't want to keep any of the existing structures, so I don't care if anything gets swept away. I may need to do this with a bunch of sites in the future, so being able to apply the template rather than recreating from scratch might be very helpful.

  Read the article

• Client outlook account deleted on client system, Need to recover e-mails that are on server back cli

  - by chris

  Hello, I have 2 client compters running XP and MS office with Outlook 2007. I have a 2003 server running exchange. Clients e-mail account was removed on clients computer. But the e-mails are still on server as I see the mailbox with approx 14k of mail How do I restore the e-mail account on clients and retrieve the e-mail from server. I did not set up the outlook or exchange, so I do not know the e-mail settings. Any help? Chris

  Read the article

• How do you create a dynamic excel chart?

  - by Haris

  I am looking at creating an Excel chart that offers some interactivity. Basically, at the moment I have a chart that is detailing progress (in %) using bars. But that progress is usually made up of several other aspects. So you could have an overall progress of say 50% which would then be broken down into Graphics 75%, Sound 25%, Gameplay 50%. Now what I'd like to do is find a way to stack those bars, so that I have the bar showing the overall progress and only when I click on that bar the other, more detailed progress bars appear. Is there a way to do this in Excel? Thanks in advance!

  Read the article

• RTF File Opens as Read Only from Document Management System (Does not happen for all users)

  - by Dave

  We have a third party system in place that as one part of its duties hosts RTF files that a user can open, make changes to, and save back into the document management system. Recently we have begun upgrading users to Office 2007 from 2003. We are now hearing that when some users open these documents, they open as Read Only (even though there is no document protection in place and the files are set for Unrestricted Access). Other users though, who also have Word 2007, report no problems. There were no problems for anyone when Word 2003 was being used. I'm sure it's a setting in Word but I'm having a lot of difficulty in identifying where the issue could be. Looking for any assistance on why these RTF files are opening as Read Only for some and not for others when using Word 2007. Thanks! Dave

  Read the article

• MS Access: Why can I no longer right-click to add a hyperlink?

  - by gef05

  I've been working in an MS Access system for a while now. It's a form system where users enter data, add links, contacts etc. Pretty simple. On the form is a hyperlink field. For months I could right-click the field, and from the popup context menu select Hyperlink Add a hyperlink (something like that). This would allow me to browse to a network location, select a folder, click okay, and have the path automatically added to the field. Then it stopped working. It works fine for everyrone else but not me. What's stranger, if I go to another machine and login, I get the functionality back. Any ideas?

  Read the article

• Using Office 2003 normal.dot in Office 2010?

  - by TJ

  I have a user who I have upgraded from office 2003 to Office 2010. This user relies on his custom auto correct that he built into his normal.dot file for Word 2003. He would not like to have to reenter all 200 of his auto corrects. How can I convert his old Normal.dot file with auto corrects to the new Normal.dot for Office 2010?

  Read the article

• Display date difference in MS Word

  - by serhio

  I have an CV and would like to automatically update my age when opening. So, what formula should I insert in a MS Word field? Something like { CREATEDATE \@ "01/01/1983" - CREATEDATE \@ "dd/MM/YYYY"} ?

  Read the article

• Upgrade Windows 7 to Windows 8 using Technet?

  - by WillyWonka

  I want to go get a TechNet subscription to test some Windows software before I buy it. I want to replicate upgrading Windows 7 to Windows 8 with specific software in a virtual machine then see how stable or if possible to do it at all. I looked at the list of software but they only show Windows 8 Pro or Enterprise. Do you know if there is an Windows 7 to 8 Upgrade ISO available for Technet Standard or Pro?

  Read the article

• Excel 2003 Freezes When Worksheet with PivotTable Selected

  - by Max

  All of the sudden, my Excel 2003 began an odd behavior today. Whenever I click on a worksheet tab that has a PivotTable on it, I become unable to click on any other tabs or on the menu with the options to minimize, maximize, and size at the top left of the worksheet window. I am left unable to click on the other tabs until I double-click inside a cell in the PivotTable worksheet and get a blinking curor as if to type. Then, I can navigate to other tabs normally. I can't think of any major changes I have made to my computer in the last day that would have caused this. I did instiall PC Tools antivirus over a week ago, and since that time have noticed my computer behaving in odd ways, but excel has been just fine until now. Does anyone have any thoughts on what might cause this? Thanks so much.

  Read the article

• Independent SharePoint Trainer in DC ~ I conduct, teacher-led SHAREPOINT user training anywhere ~

  - by technical-trainer-pro

  Your options: "*interactive" hands-on VIRTUAL or CLASSROOM style training to all SharePoint Users & Site Admin owners.* I also develop customized classes tailored to the specific design of any SharePoint Site - acting as the translator for those left to understand and use it, on an everyday basis. Audience: users,clients,stakeholders,trainers Areas: functionality,operations,management, user site customization,ITIL training, governance process,change mangement and industry or client specific scenerios. INDIVIDUAL RATE- $300 to join any class *(1)* GROUP RATE - $1500 for a private group of (6-10) Flexible Scheduling contact me : [email protected] Local to DC/MD/VA ---can train hands-on anywhere~

  Read the article

• My HiperV Virtual Server stops with critical error.

  - by Svisstack

  Hello, I have problem with my HyperV virtual server, he minute after start was stopping with critical error. Where in the system i can find more information about this error?

  Read the article

• PowerPoint shows error message when opening PPT file from email

  - by Andreas

  When I open a PowerPoint file which I received via e-mail in PowerPoint 2010, I get the following error message: PowerPoint found an error that it can't correct. You should save presentations, exit, and then restart PowerPoint. Even if you click OK the error message appears again and again and makes it difficult to quit PowerPoint. Furthermore it gives no indication what caused the problem or how to solve it.

  Read the article

• how to save ms office documents directly to google documents

  - by user23950

  I tried this program called office sync but it does not work on ms office 2003. It prompted me to input the username & password in google docs but when I try to look up the document that I save 20 minutes later nothing show up in the recent documents.

  Read the article

• Inserting a very long Excel table into Word

  - by Fred

  I have a very long excel (2003) s/sheet with in excess of 600 rows that I want to paste into an MS Word document (also 2003). However, I want to ensure that: 1) The header row appears automatically at the top of each page. 2) The s/sheet automatically formats to the correct page width (the one I have is slightly wider than my Word page). This can obviously be done manually by cutting and pasting each page seperately but this is very laborious and time consuming and I once saw somebody achieve this automatically (maybe with a macro) but have been unable to locate them, or the methodology. Can anyone please assist? Thanks in advance, Fred.

  Read the article

• How to apply formatting to particular font type in MS word 2007

  - by Mirage

  I have word document with 100 pages. Now in that Doc i have different language font in one line and then English translation in other line. Now i want to format the language font only e.g i want to change the color that font. How can do that without changing color of English font. I don't want to do manually by selecting each line and apply setting

  Read the article

• Access losing db connections

  - by Dwight T

  I have a weird problem going on at work. People have been using MS Access to connect to sql server db and lately people are getting sporadic problems with connecting to the servers. It's not always the same users and it's not always a problem, which makes it a real pain to try to solve. One example of a related problem. A person has a linked table to a table and she would filter the table or write a query on the table to return where itemsku = 'ABCD1234'. It would return one record but the ItemSku LMKN7486 and everytime it would return the wrong record but consistently the wrong record so itemsku abcd1234 always returned LMNK7486 One would think it might be a driver problem, but it also could be a user problem. Just posting the question to see if anyone else has had similar senerios. Thanks

  Read the article

• Page numbers in Word 2007

  - by ldigas

  I'm gonna skip the usual rant which normally follows upon mention of the words "Word 2007" I have a numbered section. Which has page numbers. Then, I insert a new section break at the end of the current section ... go to page numbers, format ..., and "start at ...", and the new section then has a new page numbering (starting with some other number). But, how do I after inserting a new section break, remove the page numbering in the new section ? If I go to remove page numbers option, Word removes the numbers from the new, but also from the old section (i.e. all of them). Help ... time is short ...

  Read the article

• Does OneNote have palm rejection or a hand rest spot?

  - by Richard DesLonde

  I just bought an Acer Iconia W500. I really wanted to use it for taking notes and having all the amenities of a full blown computer without the size. Using OneNote to take notes, I notice I can't rest my hand on the screen. I have read some about this and it seems the very best solution is to get a tablet with active digitizer technology, but there aren't too many with this and it is expensive. So barring that, is there any way I can rest my hand on the tablet screen while taking notes in OneNote? Or am I relegated to hovering my hand over the screen while I write notes? Does OneNote have a palm rest area or some sort of palm rejection?

  Read the article

• Looking for a text editor with navigation/categorization

  - by RadGH

  I've been looking for a text editor that automatically (or at least makes it easy to-) make some sort of navigation. Adobe Reader has this functionality with its bookmark system: Right now, though, I'm using Word 2007. For each section, I go Insert Bookmark, highlight the text, copy/paste the text as the link information, and it appears at the top of the document. I've made a macro to add bookmarks easier, but it's still pretty awful, and the bookmarks are still at the top of the page (rather than in the sidebar, where it's always accessible) Honestly, I would just prefer to write it in a PDF like in that screenshot. But any text editor with this type of functionality would work. It just needs basic formatting options, bold/font size, underline, images, maybe tables.

  Read the article

• Always show toolbars in Word 2003

  - by Franklin Albricias

  Hello: I have a custom toolbar associated with some VBA macros in Word 2003. I want this toolbar to alway be visible, independent of the doc or template open. Is there any way of doing it? Thanks in advance.

  Read the article

• Exchange Online SMTP Not Working With Any Email Client

  - by emre nevayeshirazi

  I am trying to switch our company mail server to exchange online. I have successfully added my domain and users and can send and receive mails through Outlook Web App. I can also send and receive if I configure my Outlook 2013 client using Exchange protocol. However, some folks in company are using Thunderbird and some old Outlook Clients. For those, I tried to connect to Exchange via IMAP/SMTP. This is what I use, For incoming, IMAP / Port : 993 with SSL / Host : outlook.office365.com For outgoing, SMTP / Port : 589 with TSL / Host : smtp.office365.com I can receive emails, however I could not be able to send emails. I keep getting An error occurred while sending mail. The mail server responded: 4.3.2 Service not active. Please verify that your email address is correct in your Mail preferences and try again. My username and password are correct, I am using my mail address as my username to mailbox. I also tried sending mail via C# application which was working for outlook.com and gmail.com SMTP settings. It also fails to send emails and returns the same error code. I thought TB and other old clients such as Office 2003 might not support Exc. Online so I tried same settings in Office 2013. It successfully connected my mailbox when checking for configuration but failed in sending test message and returned the same error code. Configuration for incoming and outgoing mailbox are taken from here. They are also available on Office 365 user page and they are same. What could be the reason for error ?

  Read the article

• Auto-responder rule in Outlook 2010 produces double signature (but only to certain emails)

  - by Austin ''Danger'' Powers

  I have set up an auto-responder in Outlook 2010 using a custom template, as a staff member will be on vacation for 6 weeks. It works perfectly, apart from the fact certain people receive two signatures at the bottom of the message instead of one. When reviewing the "sent" folder, there is no sign of double signatures. In the custom template, there is only 1 copy of the signature. Signatures are set to be applied automatically to new messages or replies- however, if I remove the signature from the template, then it seems no one receives a response with the signature. People sending from Hotmail accounts do not receive a duplicate signature. Gmail users do see a duplicate signature. Does anyone have any idea what could be causing this?

  Read the article

• Find the product key I entered for MS Office on Mac

  - by Rick Reynolds

  I have several legal license keys for Office:mac 2008. I want to do a quick audit of the two machines I've installed office on and verify which license keys are being used where. But I don't see the license key anywhere on the about dialog (or elsewhere). I've seen other postings on the 'net directing me to look at various .plist files, but those only give me the "Product ID" which is different from the license key (which MS calls the "Product Key" on the little sticker). Is there a way outside of calling MS to correlate the Product Key (which is required for installation and is the real license key) to the Product ID I see in the app itself?

  Read the article

• Word 2007 Page vertical and header/footer vertical

  - by elhombre

  Hi all In Word 2007 I have a Page which had to be changed to vertical mode. Now when I look at the page it's vertical but the header/footer are still horizontal is there a way to change them to the existing alignment?

  Read the article

< Previous Page | 152 153 154 155 156 157 158 159 160 161 162 163  | Next Page >