Divinedar

I have a worksheet of about 388 items that each item is exported into a template worksheet that is created to itemize each item. It creates the worksheets but I can't get it to stop looping at the line of code in bold comments icons. The line that it stops …

Ok I have a a list of about 392 items that needs to be put into an excel form. I manage to get Column A (which is the inserted worksheet names) to name the worksheets that is automatically inserted. I have attached an example of my table When the code …

I need to take a video posted on youtube that was once a powerpoint and convert back to a powerpoint and print. I can't seem to find a converter for mp4 to ppt, i.e., that would work once I have the video download. Obviously there has to be a free …

I have a document that include the chapter numbers in the page numbering, but when I run the table of content I can't get it to include the chapter numbers with the page numbering in the table of content. Also the first 17 pages of the table of content is …

I have several worksheets that list the following data on each sheet but different project number: A B C D E F G Date Hours Project Description Task/Account Comments Employee Hours Total Aug-19 4.00 P09998 BID&PROPOSAL PRE-PREPOS P09998 Mexico iDirect; James 34.00 Aug-20 4.00 P09998 BID&PROPOSAL PRE-PREPOS P09998 Staff Meeting, …

Can anyone help. I have the following code: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 7 Then MakeHyperLink Target, "Q:\" End If End Sub Option Explicit Private Files As Dictionary Private StrFile As String Dim StrFlePath As String, FleCollection, fle, f1, fs, f2, subfld Sub MakeHyperLink(InRange As Range, …

I have the following code that hyperlinks the file to a cell in excel when you type in the file name. I need to alter this code and not sure how. I need for the code that when you type in file name it also finds the filename path and …

I am trying to reference a cell with a date from one worksheet to the other. I am using ='Statistics MVP'!A16 but it doesn't give me the date format it just gives me the number 41125 or any other number. When I format as a date form I get 1/0/1900 …

I'm still having a problem with this. Can someone help? Let me explain a little more of what I need. Range("G3:G" & Cells(65536, "A").End(xlUp).Row).Select Selection.FormulaR1C1 = _ "=IF(ISNA(VLOOKUP(RC[-6],SUMMARY2!C[-6]:C,7,0)),35,VLOOKUP(RC[-6],SUMMARY2!C[-6]:C,7,0))" Sub Compare() Worksheets("SUMMARY2").Visible = True I'm still having a problem with this. Can someone help? Let me explain a little more of …

The attached excel worksheet can explain better of what I need. I need to calculate the attached based on fiscal year starting with August and ending in July for the next 5 years. If you have any other questions for better understanding please let me know.

I am unable to attach documents. I click on Files add the document but it seems like the part that says Upload Attachments should be a button to attach the documents but it's not indicated as a button. Is there something I should do to get an attachment to attach …

Not sure if this can be done. There are word files in a directory with all familiar names. i.e. fr001, fr002, fr003, etc... all with the extension .doc. I would like to know is there a code that will link an excel file to a directory and then be able …

I am trying to do the following in excel 2010: For instance: If I have a directory file name "Brazilian Navy Ku" and then I have another directory file folder name " Brazilian Aeronautical VSAT Spares"; then it will go through the first directory file folder name, search for excel …

I have the code below and what it does is I have 2 summary sheets (Summary and Summary2). I have a rebuild code that whenever changes are made that would change the Summary sheet, the Summary sheet is copied to Summary2 as a backup copy. The code below keeps track …