This is a blog which will post useful infomation about fixing computer errors. To help people troubleshoot errors, speed up computers and share good apps.

9/23/2016

How Can I Fix - copy sorted cells from 2 columns on Sheet2 to 2 columns on Sheet1?

copy sorted cells from 2 columns on Sheet2 to 2 columns on Sheet1

in columns A and B on Sheet 2, I typically have the following:

hot12030     148 TX

hot1804       214

hot11750     A

hot21390     17 RH

ALT11980    Exit_A

hot51760     C

ALT2247     36



I need to copy the cells that start with a numeric value in column B (with their equivalent cells in column A), to columns D and B respectively on Sheet1.
I then need to do the same thing with cells that start with alpha values to columns D and B respedtively.
hot12030   148 TX
hot1804     214
hot21390   17 RH
ALT247     36
hot11750     A
ALT11980   Exit_A
hot51760     C
Hope this is doable.
Thanks in advance for your help.

Anwsers to the Problem copy sorted cells from 2 columns on Sheet2 to 2 columns on Sheet1

Download Error Fixer (Free)

Try this,
Sub mcrSplit_and_Transfer()
    Dim cell As Range, ws1 As Worksheet, ws2 As Worksheet, ws3 As Worksheet
    Set ws1 = Sheets("Sheet1")
    Set ws2 = Sheets("Sheet2")
    Set ws3 = Sheets("Sheet3")
    With ws2
        For Each cell In .Cells(1, 2).Resize(.Cells(Rows.Count, 2).End(xlUp).Row, 1)
            If IsNumeric(Left(cell.Value, 1)) Then
                cell.Offset(0, -1).Copy _
                  Destination:=ws1.Cells(Rows.Count, 2).End(xlUp).Offset(1, 0)
                cell.Copy _
                  Destination:=ws1.Cells(Rows.Count, 4).End(xlUp).Offset(1, 0)
            Else
                cell.Offset(0, -1).Copy _
                  Destination:=ws3.Cells(Rows.Count, 2).End(xlUp).Offset(1, 0)
                cell.Copy _
                  Destination:=ws3.Cells(Rows.Count, 4).End(xlUp).Offset(1, 0)
            End If
        Next cell
    End With
    Set ws3 = Nothing
    Set ws2 = Nothing
    Set ws1 = Nothing
End Sub

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.

Recommended Method to Repair the Problem: copy sorted cells from 2 columns on Sheet2 to 2 columns on Sheet1:

How to Fix copy sorted cells from 2 columns on Sheet2 to 2 columns on Sheet1 with SmartPCFixer?

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

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

3. When the Fixing part is done, your computer has been speeded up and the errors have been removed


Related: How Can You Update & Download NVidia 6100, 6800 GS/XT Display Driver v.260.89 WHQL,Where to Download NVidia GeForce 8800 GT WHQL-certified driver v.196.21,How to Update & Download NVidia GeForce Go 7400 Display Driver v.260.19.12,[Solved] Download NVidia GeForce GTX 460M Driver v.331.82,Download NVidia Quadro Plex Model IV VGA Driver v.304.43 Certified,Way to Download RealTek RTL8100C(L) Driver v.5.01,Way to Download RealTek RTL8100E Drivers v.694,Way to Update & Download RealTek RTL8101L Auto Installation Program v.6.110 driver,Method to Update & Download RealTek RTL8111G PXE and RPL ROM code v.2.58 driver,How to Update & Download RealTek RTL8411B(N) Driver v.10.003,Best Way to Update & Download ASUS A53SV nVidia Graphics Driver v.8.17.12.6686,Method to Herunterladen ASUS K75VJ Intel Rapid Storage Technology Treiber v.11.6.0.1030,How Can You Update & Download ASUS CG8580 Intel Chipset Driver v.9.3.0.1019,Method to Update & Download ASUS K41VD Intel INF Update Driver v.9.1.1.1015,Way to Update & Download ASUS Pro70T NB Probe v.3.0.0026 driver
Read More: Troubleshoot:continuous beeping sound on start up and cursor keeps blinking,How to Fix - create a source sheet file with data in another sheet?,Solution to Error: crashing and restarting windows explorer,How to Resolve - Counting Unique Record?,Troubleshoot:CPU utilization spikes to 100% randomly,Closing Internet Explorer causes error,Compare 2 Tables and Calculate the PROFIT Faster,Computer goes to Windows Boot Manager after Start,Connect to one of my network computer remotely when don't allow exception box Marked,computer locking up randomly
Share:

0 comments:

Post a Comment

Note: Only a member of this blog may post a comment.

Sample Text

Copyright © Fix Your PC Errors & Speed Up Your PC | Powered by Blogger Design by ronangelo | Blogger Theme by NewBloggerThemes.com