Member Avatar

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 at is to name the worksheet from the column "A" of the list of 388. I have shorten the list to work on the code. So when I'm done I would have workbook of 388 worksheets from the template made. The template worksheet name is "wbs_template" (hidden). I have attached …

Member Avatar
+0 forum 11
Member Avatar

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 names names the see it also puts that same name in cell "N8" From the table I also need for the code to put in the information from that same line to insert various cells from the table. When you look at the attachment the columns that is highlighted in …

Member Avatar
+0 forum 1
Member Avatar

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 software out there somewhere that can do this. Anyone know of one?

Member Avatar
+0 forum 1
Member Avatar

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 roman numerals and they dont appear either. I have microsoft word 2010. How can I correct this? I have tried the switches within the table of contents of that's not working either. HELP!!! This is a 300 page document and I would hate to have to do the TOC manually.

Member Avatar
+0 forum 1
Member Avatar

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, James Aug-21 8.00 P09998 BID&PROPOSAL PRE-PREPOS P09998 MTTS & TCT Drawings James Aug-22 8.00 P09998 BID&PROPOSAL PRE-PREPOS P09998 MTTS/TCT Drawings James Aug-23 8.00 P09998 BID&PROPOSAL PRE-PREPOS P09998 MTTS/TCT Drawing James Aug-19 2.00 P09998 BID&PROPOSAL PRE-PREPOS P09998 Research and John Aug-21 2.00 P13017-TELESAT RFI/ROM CISCEA P13017 Richard 13.00 Aug-22 3.00 P13017-TELESAT …

Member Avatar
+0 forum 8
Member Avatar

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, _ ToFolder As String, _ Optional InSheet As Worksheet, _ Optional WithExt As String = "doc") Dim rng As Range Dim Filename As String Dim Ext As String With Application .ScreenUpdating = False .Calculation = xlCalculationManual .EnableEvents = False End With If Files Is Nothing Then GetFileAddress End If 'check …

Member Avatar
+0 forum 2
Member Avatar

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 filename and hyperlink in the cell. This is the code: Private Sub Worksheet_Change(ByVal Target As Range) 'change "c:\tmp\" to whatever reference you need 'a cell, a public variable, a fixed string If Target.Column = 16 Then MakeHyperLink Target, "C:\Users\darlene.sippio\Documents\Temp" End If End Sub Public Function MakeHyperLink(InRange As Range, _ ToFolder …

Member Avatar
+0 forum 25
Member Avatar

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 and this is what I want to hide until a date is put in any cell that is being referenced. What I want is that if there is no date in cell A16 that I am referencing, I don't want it to show anything until a date is put in …

Member Avatar
+0 forum 2
Member Avatar

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 what I need. The code above keeps any changes made in column 9 if made on the the "SUMMARY" sheet, then it's copied to "SUMMARY2". "SUMMARY2" keeps all changes made to the "SUMMARY" sheet at all times. My problem is that it only keeps any memory down to the total …

+0 forum 0
Member Avatar

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.

Member Avatar
+0 forum 18
Member Avatar

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 to a discussion?

Member Avatar
+0 forum 1
Member Avatar

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 to type the file name within a cell and it is automatically hyperlinked to that cell?

Member Avatar
+0 forum 4
Member Avatar

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 files, open the excel file, search for any worksheet tab with tab format XX.XXX or tab format XX.XXX.XX, then retrieve information from certain cells within that excel file. I just need to be able to have it search within a folder by a certain name criteria of the folder name. …

Member Avatar
+0 forum 1
Member Avatar

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 of any changes made in columns G and I which are percentages based on whatever row it is on. So when I activate REBUILDSEL if any percetages that have been changed previously and automatically put back into the Summary sheet that is copied from Summary2. Now what I need. After …

+0 forum 0

The End.