Best System Error Solution: July 2016

Wednesday, 6 July 2016

[Solution] auto sort - I'd like to be able to create a sort button for the summary table sheet

auto sort - I'd like to be able to create a sort button for the summary table sheet

I've created a march madness spreadsheet to calculate points for each participant in an office pool. I update a master bracket, which then updates each participant's bracket. I then pulled the point totals of each sheet into a summary table. I'd like
to be able to create a sort button for the summary table sheet so I can sort the participants data (B9:N22) by the total points column (I9:I22) in decending order, after I've updated the master bracket.

Keys to the Problem auto sort - I'd like to be able to create a sort button for the summary table sheet

Download SmartPCFixer for Free Now

Note: It is recommended that you back up your files and folders before attempting this step:

Move the mouse cursor over to the upper right side of the screen.
A menu will pop up on the left. Click on the "Settings" feature on the menu.
On the Settings window, click on the "Change PC settings."
Now, left click on the "Update and recovery" feature.
For the next step, left click on the "Recovery" feature.
There is an option here saying "Refresh your PC without affecting your files." There, left click on the "Get started" button.
Now, follow the instructions on the screen to finish the Refresh process.
After the Refresh process has finished restart your Windows 8.1 or Windows 8 device.
Check again to see if the error auto sort - I'd like to be able to create a sort button for the summary table sheet has been fixed.

If you do not possess the technical expertise required to accomplish this yourself or do not feel comfortable doing so, download and install a powerful automated tool to get the job done.

Another Safe way to Repair the Problem: auto sort - I'd like to be able to create a sort button for the summary table sheet:

How to Fix auto sort - I'd like to be able to create a sort button for the summary table sheet with SmartPCFixer?

1. Click the button to download SmartPCFixer . Install it on your computer. Open it, and it will perform a scan for your computer. The errors will be shown in the list.

2. After the scan is done, you can see the errors and problems which need to be fixed.

3. The Fixing part is finished, the speed of your computer will be much higher than before and the errors have been removed.

How to Fix - Back up money 99 to a CD in windows seven 64 bit?

Back up money 99 to a CD in windows seven 64 bit

How do I back up money 99 to a CD in windows seven 64 bit?

Anwsers to the Problem Back up money 99 to a CD in windows seven 64 bit

Download Error Fixer (Free)

Do you mean backup the Money data file? If so simply copy the data file to your prefered location
PS I dont believe Money 99 is compatible with win7 64bit

Using Windows troubleshooter:

Click on Search on Charm bar and type Troubleshooting. Click on the very first option.
A new window will open. Click View all from the left pane.
Scroll down to the bottom and click on Windows update.
Troubleshooter window for Windows update will pop up. Click on NEXT. It may ask you for administrative permission.
The troubleshooter will automatically detect problems and fix it.
Now, close this window and try download/install the app which was previously showing error.

Another Safe way to Fix the Problem: Back up money 99 to a CD in windows seven 64 bit:

How to Fix Back up money 99 to a CD in windows seven 64 bit with SmartPCFixer?

1. Download SmartPCFixer. Install it on your system.

2. After the scan is finished, you can see the errors and problems need to be fixed. Click Fix All.

3. The Fixing part is done, the speed of your computer will be much higher than before and the errors have been removed.

Solution to Problem: auto-filling data from one sheet to another using data validation drop down list

auto-filling data from one sheet to another using data validation drop down list

Hello friends,

I need to print JVs (based on data exported from Quickbooks) on a JV template i made in excel.
I have used data validation and v-lookup formula to create a drop-down list on the JV Template.
When i click a txn in the list the rest ** the fields are auto-filled.
See attachments.

The problem is i cannot get all the values and names on the JV template by selecting a Txn from the drop down list.

It does work if the data is contained within a single row.
But here a single trans# is using more than one row.
eg.
trans# 183 uses rows 8-10.
while data from row 8 is recognized and auto filled (using vlookup) but not from the rest of the rows.

Kindly help me.
In short i want all the data in say Trans# 183 to appear on the JV template by a single click (using a drop down list i created).

Solutions to the Problem auto-filling data from one sheet to another using data validation drop down list

Download Error Fixer for Free Now

I got through your new sample workbook and changed the formulas to suit.
The 903 transaction was the only one with more than two values but I have the formulas set to look at 30,000 rows and up to seven rows.
The range of rows has to be the same as in ROW(1:30000)
is the same number of rows as B1:B30000.
If you insert rows into the table in the JVL sheet, it may change only some of the references; e.g. B1:B30001 but leave ROW(1:30000) alone.
If so, you will have to manually fix the formulas.
All of the formulas on the JV sheets are standard.
They do not require Ctrl+Shift+Enter.
There is some custom number formatting like before.
As mentioned, you will need to find a better method of generating a transaction number list if you are going to use 30K rows of data.
I suggest a macro that will copy for unique and sort.
I've uploaded the modified sample workbook to my public
DropBox at:
ghvjg (Jeeped).xlsx

Tweak IE Options

Open Internet Explorer.
Go to "Tools > Internet Options > Advanced Tab".
Uncheck "Enable third-party browser extensions".
Click "Apply".
Reboot your computer.

Attempting to make my webpage appear the same in IE7 as it does in IE8.

Hello,
I created a webpage using IE8 and it displays really weird in IE7.
Im sure it does the same thing in IE6, etc.....
Firefox, Safari, and Opera shows up right just like IE8 does.
Research shows only solutions for websites created with IE7
to display correctly in IE8 but that is not helpful to me.
Any ideas or suggestions would help me so very much! Thanks in advance.

Keys to the Problem Attempting to make my webpage appear the same in IE7 as it does in IE8.

Download Error Fixer (Free)

Hey Mizzou626,

You can find the MSDN (Microsoft Developers Network) communities for Internet Explorer here:
· MSDN - Internet Explorer Extension Development
· MSDN - Internet Explorer Web Development

Steven
Microsoft Answers Support Engineer
Visit our
Microsoft Answers Feedback Forum and let us know what you think

Don't Download Malware

Where are you getting the download?

There are malicious people who download valid copies of a popular download, modify the file with malicious software, and then upload the file with the same name. Make sure you are downloading from the developer's web page or a reputable company.

Don't install download manager

Many sites suggest or require you to install an installer or a download manager before allowing you to download a program you may be interested in downloading. These tools almost always cause your computer more problems and may even have malware or other spyware. Avoid any site claiming anything must be installed first before you can continue with your download.

Avoid advertisements on download pages

To help make money and pay for the bandwidth costs of supplying free the software, the final download page may have ads. Watch out for anything that looks like advertisements on the download page. Many advertisers try to trick viewers into clicking an ad with phrases like "Download Now", "Start Download", or "Continue" and that ad may open a separate download.

Cancel or deny any automatic download

Some sites may automatically try start a download or give the appearance that something needs to be installed or updated before the site or video can be seen. Never accept or install anything from any site unless you know what is downloading.

Back arrow not working

I have Windows XP Home with IE 8.
Most of the time when I am surfing and try to go back a page the arrow doesn't work.
Any ideas? Thanks.

Keys to the Problem Back arrow not working

Download SmartPCFixer to Fix It (Free)

Hi harothaug,

Does the back arrow appears grayed out or does not work even if it appears active or enabled? As opening a link in new tab or new windows would not provide you with the option to go back.
Does this happen on some or all the websites you visit?
You may use the below mentioned methods and check if these help -
Method 1:
You may check if you face the same issue in No add-ons mode.
I would suggest you to use the Internet Explorer in No Add-ons mode and check if the issue persists.
To run in No Add-ons mode –
Click Start, and then type Internet Explorer in the
Start Search box.
Click Internet Explorer (No Add-Ons).
Internet Explorer opens without add-ons, toolbars, or plug-ins.
Test Internet Explorer to verify that it works correctly.
If the issue gets resolved use the below mentioned links for further resolution –
http://windows.microsoft.com/en-us/windows7/Internet-Explorer-add-ons-frequently-asked-questions
http://windows.microsoft.com/en-US/windows7/Using-the-Internet-Explorer-Add-on-Manager
Method 2:
If the issue persists, I would suggest you to reset Internet Explorer settings and check.
To reset Internet Explorer automatically, click the
Fix this problem button or link.
Click Run in the
File Download dialog box, and follow the steps in the Fix it wizard.

Fix this problem

Microsoft Fix it 50195

Disclaimer: The Reset Internet Explorer Settings feature might reset security settings or privacy settings that you added to the list of Trusted Sites.
The Reset Internet Explorer Settings feature might also reset parental control
settings.
We recommend that you note these sites before you use the Reset Internet Explorer Settings feature.

For more information about how to troubleshoot the Internet Explorer 8 issue, please refer to the following article:
You cannot view, access, or load some Web pages when you use Internet Explorer 8
http://support.microsoft.com/kb/967897
Hope this helps.
Let us know the results.
Thanks,
Meghmala – Microsoft Support
Visit our Microsoft Answers Feedback Forum and let us know what you think

Open Action Center by clicking the Start button Picture of the Start button, clicking Control Panel, and then, under System and Security, clicking Review your computer's status.

Make sure your computer has at least the minimum amount of random access memory (RAM) required to run the program that is displaying the error. Look for the program requirements online or in the packaging information.

Are the Microsoft programers working on a solution to "window looses focus" or are we on our own?

I was running XP for a long time, so I finally upgrade to 7, with the purchase of a new computer and I have this problem that I have learned is called:
window looses focus. Essentially, the window becomes unselected, whether it is a browser window, a word processer or Photoshop, it just
becomes unselected if I pause for a few moments. I have to click on it to re-establish that I am trying to scroll, or edit a photo, etcetera.

I have learned that one can do a special type of start up where you find out
which programs are stealing focus, the thing is, this wasn't a problem with XP, so I'm wondering, it there a fix in the future, that is, are the Microsoft programmers trying to fix this, or are we forever left to deal with this on our own?

Falcon

Keys to the Problem Are the Microsoft programers working on a solution to "window looses focus" or are we on our own?

Download SmartPCFixer to Fix It (Free)

If you failed to fix it, another option is to call Microsoft and walk through the process with a technician. To do this, dial "1-800-936-5700". Explain the error that you received and the steps in the update process during which it was displayed. The technician will be able to walk through the steps from getting a new product key to finishing the installation.

Avery address labels 8620 not lining up

Avery address labels are not lining up correctly in boxes.
Checked with Avery, they said to check with Epson.
Epson said check with Dell.
Dell said check with Microsoft and Microsoft said it'll cost $59+tax for help with an IT.
It shouldn't be so complicated.
I've changed margins which didn't work, tried numerous Avery templates but still the labels are printing out of line.

Anwsers to the Problem Avery address labels 8620 not lining up

Download SmartPCFixer to Fix It (Free)

Note: It is recommended that you back up your files and folders before attempting this step:

Move the mouse cursor over to the upper right side of the screen.
A menu will pop up on the left. Click on the "Settings" feature on the menu.
On the Settings window, click on the "Change PC settings."
Now, left click on the "Update and recovery" feature.
For the next step, left click on the "Recovery" feature.
There is an option here saying "Refresh your PC without affecting your files." There, left click on the "Get started" button.
Now, follow the instructions on the screen to finish the Refresh process.
After the Refresh process has finished restart your Windows 8.1 or Windows 8 device.
Check again to see if the error Avery address labels 8620 not lining up has been fixed.

If you do not possess the technical expertise required to accomplish this yourself or do not feel comfortable doing so, download and install a powerful automated tool to get the job done.

Avoiding an occasional error message

Hi,
I have this macro which works great except the Run-time error when it finds the blank cell in column C.
Here how it works, column C contained the list of full-names (some with middle initial).
Column A and B are the blank columns to receive data of
first and last name from the column C.
It inserts comas if the letters are less than four characters long and also turns the text of column A and B into sentence case and column C in capital letters.
It really doing its job but the only thing that I didn’t
like is that when it finds any blank cell in column C an windows pop up with Run time error ‘13’ Type mismatch.
I can live with it by clicking End but it would be nice if it terminate peacefully (without any message) and without filling #Value! In column A
and B’s rows.
The blank cell appears in column C because the sheet have three hundred rows and the names-list is sometimes less than a three hundred in row so whatever cell lefts blank in column C that’s when error window appears.
Any help in this regard will
be greatly appreciated. No shortcuts or hints please, I am not an expert.
Thanks

Option Explicit
Sub Names()
Range("A2:A" & Cells(Rows.Count, "C").End(xlUp).Row).Formula = _
"=LEFT(C2,FIND("" "",C2)-1)"
Range("B2:B" & Cells(Rows.Count, "C").End(xlUp).Row).Formula = _
"=IFERROR(MID(C2,FIND("" "",C2,FIND("" "",C2)+1)+1,20),MID(C2,FIND("" "",C2)+1,20))"
Dim cll As Range
For Each cll In Intersect(ActiveSheet.UsedRange, Columns("A:B"))
If Len(cll.Value) < 4 And cll.Value <> "" _
Then cll.Value = Left(cll.Value & ",,,,", 4)
cll.Value = UCase(Left(cll.Value, 1)) & LCase(Mid(cll.Value, 2, 255))
Next cll
For Each cll In Intersect(ActiveSheet.UsedRange, Columns("C:C"))
cll.Value = UCase(cll.Value)
Next cll
End Sub

Anwsers to the Problem Avoiding an occasional error message

Download SmartPCFixer for Free Now

Does this code do what you want?
Sub Names()
Dim cll As Range
Range("A2:A" & Cells(Rows.Count, "C").End(xlUp).Row).Formula = _
                            "=LEFT(C2,FIND("" "",C2&"" "")-1)"
Range("B2:B" & Cells(Rows.Count, "C").End(xlUp).Row).Formula = _
        "=IF(LEN(C2)>LEN(SUBSTITUTE(C2,"" "","""")),TRIM(" & _
        "RIGHT(SUBSTITUTE(C2,"" "",REPT("" "",99)),99)),"""")"
For Each cll In Intersect(ActiveSheet.UsedRange, Columns("A:B"))
    If Len(cll.Value) < 4 And cll.Value <> "" Then _
           cll.Value = Left(cll.Value & ",,,,", 4)
    cll.Value = UCase(Left(cll.Value, 1)) & LCase(Mid(cll.Value, 2, 255))
Next cll
For Each cll In Intersect(ActiveSheet.UsedRange, Columns("C:C"))
    cll.Value = UCase(cll.Value)
Next cll
End Sub

Boot in Safe Mode:

Open Run command as previously described
Type MSConfig
Click on Boot tab
Tick Safe boot in Boot option
Select Network
Click Apply and OK
Reboot your system

Your system will boot in Safe mode with Networking. You may now try and open Windows Store and should not see any errors.

Backing Up Dual Core Computer with Windows 7

I have a Lenovo T400 that was upgraded last week from Windows XP to Windows 7 Home Premium (64 bit).
I also doubled my memory from 2 gigs to 4 gigs.
The Lenovo program I previously used to back up my computer is no longer working so I'm wondering if I
can use Windows 7 instead.
I have an Intel Dual Core CPU.
I'd like to use the internal backup system rather than buying an external device.
When I try to set up the backup function, the only option I get is to back up on a DVD/CD.
Is there a way to do an internal
backup?

Solutions to the Problem Backing Up Dual Core Computer with Windows 7

Download SmartPCFixer to Fix It (Free)

Wednesday, 6 July 2016

auto sort - I'd like to be able to create a sort button for the summary table sheet

Keys to the Problem auto sort - I'd like to be able to create a sort button for the summary table sheet

Note: It is recommended that you back up your files and folders before attempting this step:

Another Safe way to Repair the Problem: auto sort - I'd like to be able to create a sort button for the summary table sheet:

How to Fix auto sort - I'd like to be able to create a sort button for the summary table sheet with SmartPCFixer?

Back up money 99 to a CD in windows seven 64 bit

Anwsers to the Problem Back up money 99 to a CD in windows seven 64 bit

Using Windows troubleshooter:

Another Safe way to Fix the Problem: Back up money 99 to a CD in windows seven 64 bit:

How to Fix Back up money 99 to a CD in windows seven 64 bit with SmartPCFixer?

auto-filling data from one sheet to another using data validation drop down list

Solutions to the Problem auto-filling data from one sheet to another using data validation drop down list

Recommended Method to Fix the Problem: auto-filling data from one sheet to another using data validation drop down list:

How to Fix auto-filling data from one sheet to another using data validation drop down list with SmartPCFixer?

Attempting to make my webpage appear the same in IE7 as it does in IE8.

Keys to the Problem Attempting to make my webpage appear the same in IE7 as it does in IE8.

Don't Download Malware

Recommended Method to Repair the Problem: Attempting to make my webpage appear the same in IE7 as it does in IE8.:

How to Fix Attempting to make my webpage appear the same in IE7 as it does in IE8. with SmartPCFixer?

Back arrow not working

Keys to the Problem Back arrow not working

Recommended Method to Fix the Problem: Back arrow not working:

How to Fix Back arrow not working with SmartPCFixer?

Are the Microsoft programers working on a solution to "window looses focus" or are we on our own?

Keys to the Problem Are the Microsoft programers working on a solution to "window looses focus" or are we on our own?

Recommended Method to Fix the Problem: Are the Microsoft programers working on a solution to "window looses focus" or are we on our own?:

How to Fix Are the Microsoft programers working on a solution to "window looses focus" or are we on our own? with SmartPCFixer?

Avery address labels 8620 not lining up

Anwsers to the Problem Avery address labels 8620 not lining up

Note: It is recommended that you back up your files and folders before attempting this step:

Recommended Method to Fix the Problem: Avery address labels 8620 not lining up:

How to Fix Avery address labels 8620 not lining up with SmartPCFixer?

Avoiding an occasional error message

Anwsers to the Problem Avoiding an occasional error message

Boot in Safe Mode:

Recommended Method to Repair the Problem: Avoiding an occasional error message:

How to Fix Avoiding an occasional error message with SmartPCFixer?

Backing Up Dual Core Computer with Windows 7

Solutions to the Problem Backing Up Dual Core Computer with Windows 7

How to Avoid Downloading Malware

Recommended Method to Fix the Problem: Backing Up Dual Core Computer with Windows 7:

How to Fix Backing Up Dual Core Computer with Windows 7 with SmartPCFixer?