Solved

Appending an Excel database

Posted on 2014-02-07
31
113 Views
Last Modified: 2014-04-17
A workbook was created, with the assistance of gowflow, that creates a database from selected workbooks, with each workbook containing three seperate worksheets,  and is then combined into a single workbook with three worksheets of the same type of data as the indidividual workbooks.

The end result is one database type workbook that has the data from multiple workbooks, by worksheets.  Usually there is one created for each day.

In completing a reformatting process, would like to have the current day's "data rows of interest", within the three worksheets, which are all bolded, minus the headers, and have them append this "database" as the report is completed.

The name of the file that contains the data from each days report is called: Daily Report File.xlsx

Cook09
0
Comment
Question by:Cook09
  • 17
  • 14
31 Comments
 
LVL 29

Expert Comment

by:gowflow
ID: 39842615
Could you pls attach a file that would help understanding what you want ?
gowflow
0
 

Author Comment

by:Cook09
ID: 39842752
gowflow,
Here are the two.  What I failed to mention was that any other sheet that has the
name "Posted Late"  should be placed within the Posted Late worksheet, To make it more useful, the date that these were generated should be added. There's an example within the Daily-Report-File.

Cook
Daily-Report-File.xlsx
-02.06.14-Error-Log-Report-Bold-.xlsx
0
 
LVL 29

Expert Comment

by:gowflow
ID: 39842792
The files attached have no code, however you say:
A workbook was created, with the assistance of gowflow, that creates a database from selected workbooks, with each workbook containing three seperate worksheets, ....

1) Where is that code ??? Are we suppose to search 1 zillion question back in EE to find what you want ?

2) The date you have in Col A of the file Daily-Report-File.xlsx is NOT a valid Excel format date it is considered string !
How do you get the present dates there ? manually or it is system generated ? they need to be converted !!!

3) It is not clear to even writer who worked on this issue what you want. Do you want to append data to existing workbook ? if yes this means 2 items envolved
a) a workbook that contain a macro (that is not here) and also contain the data we need to append
b) an other workbook that will receive the appended data presume this one is ¿Daily-Report-File.xlsx which need confirmation and where is this workbook lying ? I mean what folder location should it be hardcoded in the macro or user set ??

gowflow
0
 

Author Comment

by:Cook09
ID: 39842892
Attached is the last workbook that you sent on this topic, with the code.

As far as the date, whatever is Excel accetable is fine, those in the workbook were manually produced.

Yes, the daily data should append what is currently in this workbook.  The current day's data is always going to be the last set of data.

In the question itself, there were two workbooks, one with a Feb 6 date, if you look, a lot of the data in the Daily File comes from that workbook, which is the "Bolded" version that we just completed.  If you want, I can send you the code for that one, but since it was just done, thought you would still have it around.

The workbooks are all in the same subdirectory and basically set as:
 vPath As Variant
 vPath =  Workbooks("Daily Report File").Path

That's what I used in the reformatting aspect of the Daily Report, as there is not one common network Drive Letter that points this subdirectory among those who may use it.

Hope that answers most of your questions.

Cook
Error-Report-Database-V02.xlsm
0
 
LVL 29

Expert Comment

by:gowflow
ID: 39843099

If you want, I can send you the code for that one, but since it was just done, thought you would still have it around.

When you post questions in EE they need to be:

1) Self explanatory
2) self documented
3) Anyone with no background of the issue should be able to assist
4) Free for all Experts equally to participate and not in favor of specific Experts as this is against rules and is called point passing and could be highly reprimanded to even lead to suspension of membership in EE.

If any special or particular need is required Experts do offer paid services and this you are now well aware of.

Please make sure all what is needed in this question is posted in this question.
Regards
gowflow
0
 

Author Comment

by:Cook09
ID: 39843244
gowflow,

Attached is a workbook that creates a Grouping by Destination and the Removal of Non-Bolded rows.  This code will allow the worksheet formatting to be more easily transferred to a central Excel Workbook.

Cook
Error-Log-Report-V03.xlsm
0
 
LVL 29

Expert Comment

by:gowflow
ID: 39843814
I am extremely sorry here,

but

We cannot act as if we are 'yourself' meaning that we are not with the full picture as if it was you.

You give the information bits and pieces and you expect us to put the whole puzzle together and guess what you want.

If you want specific help your next comment should include specific question or explanation of what need to be accomplished in detail with their supporting documents and explaining what document should do what in which document.

Beside this I am sorry but cannot provide you with help.
gowflow
0
 

Author Comment

by:Cook09
ID: 39847288
Experts,
Attached is workbook was createdthat that takes the form of a  "database", or its data is collected from multiple selected workbooks. Each selected workbook, that forms this collection, contains three to five seperate worksheets,  and is then combined into a single workbook, named Daily Report File, as the attached shows.  The three worksheets within this workbook follows the same names, for t he most part, as the individual workbooks.  The exception is that any tab that the data from any worksheet that begins with "Posted Late - xxxxx" are transferred to the Posted Late worksheet, within the Daily Report File.

The end result is one database type workbook that has the data from multiple workbooks, by worksheets.   However, data for this Daily Report File is usually created well, daily.

Would like to have the current day's "data rows of interest", within the daily worksheets, which are all bolded, minus the headers, and have them append  to the workbook Daily Report File."  

Code Progression
1. One part of the Code as illustrated in "Error-Log-Report-V02," Bolds those rows that meet the criteria found within their respective Tab (worksheet).

2. To make the process easier yet, some code was developed to remove the non-bolded rows, and only leave the Bolded rows, that are what is really examined.  This is done through the code found in "Error-Log-Report-V03"  Running the Macro demonstrates its effect.

What is desired currently, is that the bolded rows are appended to the Daily Report File, so that it becomes a daily log file.


The code doesn't have to mirror V03, but is provided as an example. As can also be seen, what is needed is date that each row was generated.  This can be seen in the Daily Report File.

Thanks,
Cook09
Daily-Report-File.xlsx
Error-Log-Report-V02.xlsm
Error-Log-Report-V03.xlsm
0
 
LVL 29

Expert Comment

by:gowflow
ID: 39847882
Please correct my understanding:

The bolded rows Exist in the Daily-Report-File and you need a routine to locate each and every one and update the date of the item in Col A

or

You need a routine altogether that will update the bolded rows to the Daily-Report-File and also by the same token save the date as well in Col A

??
gowflow
0
 
LVL 29

Expert Comment

by:gowflow
ID: 39847981
Also as far as the date to append it is not clear to me what date you want.
I can see that in each worksheet you have different dates
like in
Misdelivered: Date Departed      Date Received
Late & Missing: Date Departed      Arrival Date
Posted Late 01-13 PM: Batch Posted      Sched. Departure

Which date is to be used ? for sure after answering past comment.
gowflow
0
 

Author Comment

by:Cook09
ID: 39848204
gowflow...

You need a routine altogether that will update [append] the bolded rows to the Daily-Report-File and also by the same token save the [current] date as well in Col A

        Yes...the above is what I would like

The Date in Column A is the Date that the report is run, or "Today's Date." That Date should be in Column A.

It is seperate from the Date Received or Sched. Depature Date.  Some items could be late, others Misdelivered, some are listed on the report several days in a row.  What the report / data should reflect, is the actual date that this information was delivered to the field offices.

Hope this provides some clarity....

Cook
0
 
LVL 29

Expert Comment

by:gowflow
ID: 39848436
ok fine

Can we incorporate this change or addition of date in a previous Sub developed called
ImportBoldedRows

or the principle is different.

In that sub, it was ran from a workbook that would open a certain user selected file and import the bolded rows in the current workbook. Would that be ok or you need a difffrent setting.

It is important to know when oyu want the macro sitting. If it can sit in the final database then this would be the most appropriate

else

you will need to clarify more.
gowflow
0
 
LVL 29

Expert Comment

by:gowflow
ID: 39850042
Any chance to have seen my last comment ?
gowflow
0
 

Author Comment

by:Cook09
ID: 39850267
gowflow,

Sorry for not getting back sooner...had some issues to take care of.

Being run at the same time as the Bolded program (removing the non-bolded rows) is fine, and pretty much what I had in mine, since they will, or can, reside in the same subdirectory.  As the user kicks of the Bolded rows program, then that would be a good place to also move those rows into this consolidated workbook.

It would also seem easier to have it all together, I believe.

Cook
0
 
LVL 29

Expert Comment

by:gowflow
ID: 39850650
You are mistaken,

this sub ImportBoldedRows
was one of the first that I developed for you that will ask for files to import and upon the choice of 1 or several files will import into the current workbook all bolded rows. This at that time started with Tracking # as the first column I see now that the first column is the date which is not a problem.

So the question can we use this same routine. I attach the original one for you to check if it is ok then I will modify it to include the date in Col A
gowflow
Error-Report-Database-V02.xlsm
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Author Comment

by:Cook09
ID: 39850952
Basing whether a row is bolded by the Tracking number is fine, the entire row should be bolded. All that is requested is that a column is inserted (A), so the entire table is in essence, shifted over by one column, and today's date is placed in column A.

The intent is to have the data append the Daily Report File, automatically, as the daily Error Log is compiled.  The file that was provided does a  great job at manually selecting which day(s) one wants the data to be imported.  But, since data is being generated daily, having it automatically append is a simpler approach and makes the current data available immediately after the Error Report is complete.

When I mention, "automatically," it can also be that there is a macro button that one clicks, that copies the bolded rows from the open or ActiveDocument, and puts those rows into the Daily Report File.

Cook
0
 
LVL 29

Expert Comment

by:gowflow
ID: 39852473
You did not answer my question:

Shall I modify Im portBoldedRows to include Date in Col A ? or your not using this Sub altogether ?
gowflow
0
 

Author Comment

by:Cook09
ID: 39853418
Okay let me try to be more clear.  

1.The date should be in Column A. - Question Answered

2. The bolded rows from an open ActiveDocument should be able to append the "Daily Report File". Whether that means using a modified version of that particular Sub or not is within your area or expertise. - Questioned Answered

Cook
0
 
LVL 29

Expert Comment

by:gowflow
ID: 39853662
Here is the code for that

Public Sub ImportBoldedRows()

Dim fn As Variant
Dim fFile As Variant
Dim FMWB As Workbook
Dim FMWS As Worksheet
Dim WS As Worksheet
Dim WSCopy As Worksheet
Dim ThisWB As Workbook
Dim FMMaxRow As Long, ThisMaxRow As Long, I As Long, RowBold As Long
Dim oExcel As Excel.Application
Dim ShtName As String, fPath As String
Dim cCell As Range
Dim ExcelLastCell As Object

If MsgBox("This process will Import in this workbook all data that is bold for all the selected workbooks and all worksheets except sheet 'Error Items' you will choose to Import." & Chr(10) & Chr(10) _
    & "In case the worksheet Exists, it will be Imported after the last existing row, and if the worksheet does not exist it will be created and imported with its original name" & Chr(10) & Chr(10) _
    & "All worksheets Imported will be be inserted after the Last Existing worksheet in this workbook." & Chr(10) & Chr(10) _
    & "Do you want to begin?", vbQuestion + vbYesNo, "Import Worksheets") = vbYes Then



    fPath = ActiveWorkbook.Path & "\"
    ChDir fPath
    fFile = Application.GetOpenFilename(FileFilter:="Excel files (*.xls*), *.xls*", MultiSelect:=True)
    
    '---> User presses Cancel button so Exit
    If Not IsArray(fFile) Then
        MsgBox ("No files selected routine will exit.")
        Exit Sub
    End If
    
    '---> Set Variables
    Set ThisWB = Application.ActiveWorkbook
    
    
    '---> Loop and Process all files
    For Each fn In fFile
        
        '---> Make sure all events and displays are off
        With Application
            .EnableEvents = False
            .ScreenUpdating = False
            .DisplayAlerts = False
        End With
        
        
        Set FMWB = Workbooks.Open(fn, UpdateLinks:=False)
        
        For Each WS In FMWB.Worksheets
            If WS.Name <> "Error Items" Then
                
                '---> Get sheet Name
                If InStr(1, WS.Name, "Posted Late") <> 0 Then
                    ShtName = "Posted Late"
                Else
                    ShtName = WS.Name
                End If
                Set cCell = WS.Cells.SpecialCells(xlLastCell)
                FMMaxRow = cCell.Row
                
                On Error Resume Next
                Set WSCopy = ThisWB.Sheets(ShtName)
            
                If Err <> 0 Then
                    '---> Create the Worksheet
                    ThisWB.Worksheets.Add after:=ThisWB.Worksheets(ThisWB.Worksheets.Count)
                    Set WSCopy = ThisWB.Sheets(ThisWB.Worksheets.Count)
                    WSCopy.Name = ShtName
                    On Error GoTo 0
                End If
                    
                
                WSCopy.DisplayPageBreaks = False
                Set ExcelLastCell = WSCopy.Cells.SpecialCells(xlLastCell)
                ThisMaxRow = ExcelLastCell.Row
                                
                '---> Check to see if New file then put the title
                I = 8
                If ThisMaxRow = 1 Then
                    For I = 1 To FMMaxRow
                        If WS.Cells(I, 1) = "Tracking #" Then
                            WS.Range(I & ":" & I).EntireRow.Copy WSCopy.Range("A1")
                            WSCopy.Range("A1").Insert shift:=xlShiftToRight
                            WSCopy.Range("A1") = "Date Imported"
                            WSCopy.Range("B1").Copy
                            WSCopy.Range("A1").PasteSpecial xlPasteFormats
                            ThisMaxRow = ThisMaxRow + 1
                            Exit For
                        End If
                    Next I
                Else
                    ThisMaxRow = ThisMaxRow + 1
                End If
                
                For I = I + 1 To FMMaxRow
                    If WS.AutoFilterMode = True Then WS.AutoFilterMode = False
                    If WSCopy.AutoFilterMode = True Then WSCopy.AutoFilterMode = False
                    WSCopy.UsedRange.RemoveSubtotal
                    
                    If WS.Cells(I, 1) <> "" And WS.Cells(I, 1) <> "Tracking #" And WS.Cells(I, 1) <> "Total Items:" And WS.Cells(I, "H").Font.Bold = True Then
                        WS.Range(I & ":" & I).EntireRow.Copy WSCopy.Range("A" & ThisMaxRow)
                        WSCopy.Range("A" & ThisMaxRow).Insert shift:=xlShiftToRight
                        WSCopy.Range("B" & ThisMaxRow).Copy
                        WSCopy.Range("A" & ThisMaxRow).PasteSpecial xlPasteFormats
                        WSCopy.Range("A" & ThisMaxRow) = Format(Now, "mm/dd/yyyy")
                        WSCopy.Range("A" & ThisMaxRow).EntireRow.Interior.ColorIndex = 0
                        WSCopy.Range("A" & ThisMaxRow).EntireRow.Font.ColorIndex = 1
                        RowBold = RowBold + 1
                        ThisMaxRow = ThisMaxRow + 1
                    End If
                
                Next I
            
                    
            End If
            WSCopy.UsedRange.EntireColumn.AutoFit
            WSCopy.UsedRange.EntireColumn.HorizontalAlignment = xlCenter
        Next WS
            
        '---> Close FM workbook
        FMWB.Close savechanges:=False
        Set FMWB = Nothing
                        

    Next fn
    
    '---> Re-display
    With Application
        .EnableEvents = True
        .ScreenUpdating = True
        .DisplayAlerts = True
    End With
            
    '---> Advise user of results
    MsgBox ("Result of Import:" & Chr(10) _
        & "A total of: " & RowBold & " Bolded rows imported.")

End If
End Sub

Open in new window


The attached workbook will import the bolded rows (Col H bold) into the current workbook for any selected file in its corresponding worksheet at the end of the existing data appending in Col A the current date of when this routine is run.

Pls check it and let me know if it meet your requirement.
gowflow
Daily-Report-Database-V03.xlsm
0
 

Author Comment

by:Cook09
ID: 39857844
The attached file should show areas that need a little adjustment.

 However, the code still doesn't provide a method to append the Daily File, from an open or ActiveDocument as requested in comments, 39847288 and 39853418.

Cook
Daily-Report-Database-V03-Date-A.xlsm
0
 
LVL 29

Expert Comment

by:gowflow
ID: 39858356
for sure it not append the daily file as clearly stated this is what it does


The attached workbook will import the bolded rows (Col H bold) into the current workbook for any selected file in its corresponding worksheet at the end of the existing data appending in Col A the current date of when this routine is run.

Now this being said, I understand that you would like to have the macro sitting in your active document that would contain the new data and you wish to Export it then to your daily file ? If this is what you want then will need to set up the macro to do the reverse. and also fix the line This following ... not exported.

Prior to doing this I would have your clear confirmation that this is what you want.

gowflow
0
 
LVL 29

Accepted Solution

by:
gowflow earned 500 total points
ID: 39858399
ok here is the solution for you:
I created the below sub ExportBoldedRows that will EXPORT into a file that you select (or multiple files) the bolded rows that are lying within the active document that contain this macro.

Public Sub ExportBoldedRows()

Dim fn As Variant
Dim fFile As Variant
Dim TOWB As Workbook
Dim TOWS As Worksheet
Dim WS As Worksheet
Dim WSCopy As Worksheet
Dim ThisWB As Workbook
Dim TOMaxRow As Long, ThisMaxRow As Long, I As Long, RowBold As Long
Dim oExcel As Excel.Application
Dim ShtName As String, fPath As String
Dim cCell As Range
Dim ExcelLastCell As Object

If MsgBox("This process will Export data in this workbook all data that is bold to all the selected workbooks and all worksheets except sheet 'Error Items' you will choose to Export." & Chr(10) & Chr(10) _
    & "In case the worksheet Exists, it will be Exported after the last existing row, and if the worksheet does not exist it will be created and Exported with its original name" & Chr(10) & Chr(10) _
    & "All worksheets Exported will be be inserted after the Last Existing worksheet in the target workbook." & Chr(10) & Chr(10) _
    & "Do you want to begin?", vbQuestion + vbYesNo, "Export Worksheets") = vbYes Then



    fPath = ActiveWorkbook.Path & "\"
    ChDir fPath
    fFile = Application.GetOpenFilename(FileFilter:="Excel files (*.xls*), *.xls*", MultiSelect:=True)
    
    '---> User presses Cancel button so Exit
    If Not IsArray(fFile) Then
        MsgBox ("No files selected routine will exit.")
        Exit Sub
    End If
    
    '---> Set Variables
    Set ThisWB = Application.ActiveWorkbook
    
    
    '---> Loop and Process all files
    For Each fn In fFile
        
        '---> Make sure all events and displays are off
        With Application
            .EnableEvents = False
            .ScreenUpdating = False
            .DisplayAlerts = False
        End With
        
        
        Set TOWB = Workbooks.Open(fn, UpdateLinks:=False)
        
        For Each WS In ThisWB.Worksheets
            If WS.Name <> "Error Items" Then
                
                '---> Get sheet Name
                If InStr(1, WS.Name, "Posted Late") <> 0 Then
                    ShtName = "Posted Late"
                Else
                    ShtName = WS.Name
                End If
                Set cCell = WS.Cells.SpecialCells(xlLastCell)
                ThisMaxRow = cCell.Row
                
                On Error Resume Next
                Set WSCopy = TOWB.Sheets(ShtName)
            
                If Err <> 0 Then
                    '---> Create the Worksheet
                    TOWB.Worksheets.Add after:=TOWB.Worksheets(TOWB.Worksheets.Count)
                    Set WSCopy = TOWB.Sheets(TOWB.Worksheets.Count)
                    WSCopy.Name = ShtName
                    On Error GoTo 0
                End If
                    
                
                WSCopy.DisplayPageBreaks = False
                Set ExcelLastCell = WSCopy.Cells.SpecialCells(xlLastCell)
                TOMaxRow = ExcelLastCell.Row
                                
                '---> Check to see if New file then put the title
                I = 8
                If TOMaxRow = 1 Then
                    For I = 1 To ThisMaxRow
                        If WS.Cells(I, 1) = "Tracking #" Then
                            WS.Range(I & ":" & I).EntireRow.Copy WSCopy.Range("A1")
                            WSCopy.Range("A1").Insert shift:=xlShiftToRight
                            WSCopy.Range("A1") = "Date Imported"
                            WSCopy.Range("B1").Copy
                            WSCopy.Range("A1").PasteSpecial xlPasteFormats
                            TOMaxRow = TOMaxRow + 1
                            Exit For
                        End If
                    Next I
                Else
                    TOMaxRow = TOMaxRow + 1
                End If
                
                For I = I + 1 To ThisMaxRow
                    If WS.AutoFilterMode = True Then WS.AutoFilterMode = False
                    If WSCopy.AutoFilterMode = True Then WSCopy.AutoFilterMode = False
                    WSCopy.UsedRange.RemoveSubtotal
                    
                    If WS.Cells(I, 1) <> "" And WS.Cells(I, 1) <> "Tracking #" And WS.Cells(I, 1) <> "Total Items:" And InStr(1, LCase(WS.Cells(I, 1)), "the following") = 0 And WS.Cells(I, "H").Font.Bold = True Then
                        WS.Range(I & ":" & I).EntireRow.Copy WSCopy.Range("A" & TOMaxRow)
                        WSCopy.Range("A" & TOMaxRow).Insert shift:=xlShiftToRight
                        WSCopy.Range("B" & TOMaxRow).Copy
                        WSCopy.Range("A" & TOMaxRow).PasteSpecial xlPasteFormats
                        WSCopy.Range("A" & TOMaxRow) = Format(Now, "mm/dd/yyyy")
                        WSCopy.Range("A" & TOMaxRow).EntireRow.Interior.ColorIndex = 0
                        WSCopy.Range("A" & TOMaxRow).EntireRow.Font.ColorIndex = 1
                        RowBold = RowBold + 1
                        TOMaxRow = TOMaxRow + 1
                    End If
                
                Next I
            
                    
            End If
            WSCopy.UsedRange.EntireColumn.AutoFit
            WSCopy.UsedRange.EntireColumn.HorizontalAlignment = xlCenter
        Next WS
            
        '---> Close TO workbook
        'TOWB.Close savechanges:=True
        Set TOWB = Nothing
                        

    Next fn
    
    '---> Re-display
    With Application
        .EnableEvents = True
        .ScreenUpdating = True
        .DisplayAlerts = True
    End With
            
    '---> Advise user of results
    MsgBox ("Result of Export:" & Chr(10) _
        & "A total of: " & RowBold & " Bolded rows Exported.")

End If
End Sub

Open in new window


In the attached workbook you will see that I kept the former ImportBoldedRows and created a new ExportBoldedRows that will just do the opposite of what the Import did. At the end of running you will get a messagebox with the total rows Exported. The file chosen will not be saved but will be kept open for you to check if all is ok.

The instruction to save and close the document is there but commented out (like disabled) until you are confident with the macro then it can be activated.

Let me know your comments.
gowflow
Daily-Report-Database-V04.xlsm
0
 

Author Comment

by:Cook09
ID: 39859747
gowflow,

Perfect....There are two options and a macro button makes it somewhat seamless in the update.  It provides an easy method to update the daily.  Appreciate your effort in providing this option.

Cook
0
 

Author Closing Comment

by:Cook09
ID: 39859752
The final product meets the intent of the question and the solution allows us to move forward.
0
 
LVL 29

Expert Comment

by:gowflow
ID: 39860475
tks your comments and glad it finally met your requirements.
gowflow
0
 
LVL 29

Expert Comment

by:gowflow
ID: 39861110
Should you need more help pls post a link of a new question in here.
gowflow
0
 

Author Comment

by:Cook09
ID: 39863200
Would you mind answering a question for me?

What would be the advantages / disavantages of creating / modifing the ribbon and adding the code to it....this would be for me so I'm not always adding/disabbling Personal.xlsb.  Is that a fair question to ask within EE? I would think so, I know Patrick Baker would help me with almost anything.

Cook
0
 
LVL 29

Expert Comment

by:gowflow
ID: 39864082

 I would think so, I know Patrick Baker would help me with almost anything.

Why you ask me then ? Ask him
gowflow
0
 

Author Comment

by:Cook09
ID: 39883810
Sorry it has taken so long to get back to you...I would ask Patrick, except he died a couple of years ago.  At the time he was known by quite a few,

http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_27286546.html

Cook
0
 
LVL 29

Expert Comment

by:gowflow
ID: 39884888
I am sorry to hear that.
0
 

Author Comment

by:Cook09
ID: 40008048
There is a fairly straightforward VBA question that I just asked.  Hope things are going well.
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Suggested Solutions

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

759 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now