Merge all worksheets of active workbook into one worksheet with VBA code

VBA Code to merge excel worksheets:

1. Hold down the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window.

2. Click Insert > Module, and paste the following code in the Module Window.

Sub Combine()

Dim J As Integer

On Error Resume Next

Sheets(1).Select

Worksheets.Add

Sheets(1).Name = "Combined"

Sheets(2).Activate

Range("A1").EntireRow.Select

Selection.Copy Destination:=Sheets(1).Range("A1")

For J = 2 To Sheets.Count

Sheets(J).Activate

Range("A1").Select

Selection.CurrentRegion.Select

Selection.Offset(1, 0).Resize(Selection.Rows.Count - 1).Select

Selection.Copy Destination:=Sheets(1).Range("A65536").End(xlUp)(2)

Next

End Sub

Notes:
(1) Your data must start from A1, if not, the code will not take effect.
(2) Your data must have the same structure.
(3) This code only can combine all worksheets of the active workbook, if you want to merge worksheets from multiple workbooks, this code will not work.

Photoshop Keyboard Shortcuts

For Photo Shop beginners

InfoPath - Clear cache form in local system

When loading an InfoPath form from an intranet/Sharepoint etc, the form template is downloaded and cached locally. Sometimes after the template has been upgraded on the server the local client doesn’t always get the upgraded form template but uses the local cached copy instead.

You can rectify this by clearing the local cache by following methods

Method 1

1. Start -> Run;
2. Infopath /cache clearall

Method 2

Dim wshShell

Dim sRun, sParam, sMsg

/* modify the path of Infopath.exe if required*/

sParam = "C:\Program Files (x86)\Microsoft Office\Office15\INFOPATH.EXE /cache clearall"

Set wshShell = Createobject("WScript.Shell")

wshShell.Exec sParam

Set wshShell = Nothing

Verification
C:\Users\[User]\AppData\Local\Microsoft\InfoPath\FormCache

Download copy of your facebook data

Interesting thing found about download FACEBOOK data, as of feature available on FACEBOOK.

You can download your information from your settings. To download your information:

• Click  at the top right of any Facebook page and select Settings
• Click Download a copy of your Facebook data below your General Account Settings
• Click Start My Archive

For further assistance you can visit FACEBOOK help center page (Click to Open)

OCR Tools To Convert Your Files Back Into Editable Documents

Google Docs has integrated OCR support. It uses the same OCR engine that Google uses to scan books and understand text in PDF files.

To get started, open the Google Docs website and start uploading a file. You can’t scan directly from your scanner into Google Docs; you’ll have to scan the document as an image or PDF file first. If you don’t have a scanner, you can try scanning a document with your smartphone’s camera.

Enable the “Convert text from PDF and image files to Google documents” check box when you upload the file.

After you upload the file, it will appear as a new text document in Google Docs.

Google Docs did a pretty good job here. It struggled to understand the web addresses, but all these tools did.

Unlike many free online OCR tools, like Free OCR (which is different from the FreeOCR below), Google Docs doesn’t have any limits on the amount of pages you can upload.

Site Reference: http://www.makeuseof.com/tag/3-free-ocr-tools-convert-files-editable-documents/

Essential keyboard shortcuts for MS-EXCEL

Keyboard shortcuts are the best way to navigate cells or enter formulas more quickly.

Control-Down/Up Arrow = Moves to the top or bottom cell of the current column Control-Left/Right Arrow = Moves to the cell furthest left or right in the current row

Control-Shift-Down/Up Arrow = Selects all the cells above or below the current cell

Shift-F11 = Creates a new blank worksheet within your workbook

F2 = opens the cell for editing in the formula bar

Control-Home = Navigates to cell A1

Control-End = Navigates to the last cell that contains data

Alt-= = Autosums the cells above the current cell

Difference Between 1D, 2D & 3D Barcode

1D Barcodes
One dimensional barcodes, also called 1D barcodes or linear barcodes are the original.The parallel black lines on the white background is the barcode used since the 1970's solely for storing product numbers and serial numbers for purposes of tracking and pricing various products.


2D Barcodes
This barcodes are called "matrix" or "two dimensional" barcodes, and they are a worthy upgrade to the old one dimensional barcode. 2D barcodes boast a higher storage space and the ability to store more than just a handful of numbers. Instead, the latest versions can store thousands of alphanumeric characters and some can even store characters from other languages! Even more impressive is how many 2D barcodes can perform other functions like launching applications on smart phones, a popular feature of QR Codes, Microsoft Tags and JagTags. The technology behind these 2D barcodes has been around for over 10 years, but popularity has just began to surge in recent years.


3D Barcodes
With two dimensional barcodes being so new, why would there be a replacement already? Three dimensional, or "3D", barcodes are more of an upgrade than an out right replacement. These barcodes are very similar to two dimensional barcodes in function. They can be scanned with simple devices like smart phones and even look the same as far as data encoding. The difference comes in durability. 2D barcodes have a built-in error correction that compensates for some smudging and distortion, but this still isn't feasible when it comes to high temperature or chemical environments. Many manufacturers have cried out for barcodes which can stand up to the temperatures and materials that they use everyday to create their products. 3D barcodes are just that. Instead of reading data based on the ratio of black to white in the barcode, they are read based on height. The 3D barcode is embossed on the product and the scanner looks at the height of each module in the barcode comparatively to decode the information inside.