Summary: Hi, I have assumed that when you want to save comments you mean a comments text box linked to a cell, and not the contents of the cell itself. You ask...
Summary: Hi, I don't write a lot of Macros for Word, so I am not sure how robust this is. Give it a try, but make sure you always have a backup! (or two). Thi...
Summary: I have created a spreadsheet which has a template form so that when information is added into an input sheet it links into the relevant section within...
Summary: Hi, Here is an example for combining your branch office reports. This example has three 'branches' There is a Master workbook named 'HeadOffice.xls' c...
Summary: I cannot use Macro that i record before Before I was create new macro in Ms word. Then I close Ms word. When I open Ms word again i cannot use Macro. ...
Summary: Hi, Here is some code to put the date into the Active Cell. Sub Enter_Date() 'Sub to enter today's date into the active cell and format the date in yo...
Summary: Here's what I want to do: From: A B C I want it to become: A A (selected row) B B (selected row) C C (selected row) How do I do this? Here is my draft...
Summary: Hi, Here is some code for a macro that deletes every row in a selection, unless the row is a multiple of 300. In my test, I entered data in Cells A300...
Summary: Hi, Make sure that the time you enter is recognized by Excel as a time. Enter an after-noon time, say 13:00 Using cell formatting: a. set the format, ...
Summary: Hi All, I am trying to reference an excel workbook that is on a LAN (at work). The idea is to copy the contents that is on sheet1 and paste it on shee...
Summary: Hi, When I wrote the code, I thought that each record started with a date on a line on its own, which I see it doesn't, hence the error. I will post a...
Summary: Hi, As far as I know, there is no simple way to do what you want. Word's control of printers is limited, and even in Visual basic the print command do...
Summary: Hi, This option uses a User Defined Function, written in Visual Basic. The cells containing the time must be formatted as Text. Before entering any ti...
Summary: Hey All I hear you guys are pretty good. I need help with an excell chart being imported into a word document. I inserted it as an object and ticked t...
Summary: Hi, It appears that what you want to do is change the row part of the formulas. Excel's Find & Replace will do this for formulas. Use Find & Replace:...
Summary: Hi, As I pointed out the sort function works only if each entry is on its own row. Rather than retyping the entries you can bring the data onto single...
Summary: Do you have access to the Update code? If so, you could add this code to it. When the Update code is run, it will check if the Weekday is Monday and i...
Summary: Hi, First a quick background on dates in Excel. Excel holds dates as numbers, starting with 1 for 01 January 1900 25 November 2009 is 40142 Excel also...
Summary: Hi, From your post, I thought that you were familiar with conditional formating formulas, which is why I didn't provide any instructions for using it,...
Summary: Assuming your data is already sorted so that the duplicates follow one another as in your example, try this code: What it does is check each item in c...
Summary: Hi, Regarding questions 1 & 2: I was not clear if the formulas you gave (=IF(F2="", "No", IF(G2>=H2, "Yes", "No")) are working or not. Times in Excel ...
Summary: The boss got a virus that rendered his drive unbootable. I plugged the drive into another computer, and I can retrieve the files that are there. Wh...
![[higher confidence]](http://static.computing.net/img/AT-red_x.gif)
- higher confidence, ![[lower confidence]](http://static.computing.net/img/AT-black_x.gif)
- lower confidence
