I need excel to return to the next row after scanning 2 columns of info in.  Don't want to use keyboard arrows
926229
It's going to be a macro.\nFrom your Excel file, press ALT+F11 to open Visual Basic Editor\nFind "ThisWorkbook" (should be located on the left hand side) and double click on it, a new white frame should open on the rignt hand side. From there, there should be a dropdown list reading "general", change it into "workbook", and paste the code below\n\nPrivate Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)\na = Target.Column\nIf a = 1 Or a = 2 Then\n    Select Case a\n    Case 1\n        Target.Offset(0, 1).Select\n    Case 2\n        Target.Offset(1, -1).Select\n    End Select\nEnd If\nEnd Sub\n\nAs I don't know which columns you are going to use to put your data in , I have chosen A and B (or 1 and 2) if you want to change it  (say D and E or 4 and 5) modify this part of the code like so\nif a=4 or a=5 then\n\nHow does it work?\nEvery time you make changes in your worksheet, like adding data (with your scan gun),  this should call the macro, which in turn first checks if the changes occurred in column A or B and then if it's in A moves one cell to the right and if it's in B moves one cell to the left and one row down.\n\nIf it's not precisely what you want, feel free to send me an email through Y Q/R
534942
There are macro programs - search under 'macro' - which will allow you to do a key sequence for regular tasks.  Or you can learn VBA if you need to do it within Office applications (and for free:))
687364
In spread sheet 1 I created the following\nSorry but the formatting is not to good.\nColumn A\n1\n2\n3\n\nColumn B\nhello\nhi\nhowdie\n\nIn spreadsheet 2 I created this\nColumn A\n1\n2\n3\n\nColumn B\n=LOOKUP(A1,Sheet1!A1:B3)\n=LOOKUP(A2,Sheet1!A1:B3)\n=LOOKUP(A3,Sheet1!A1:B3)
538436
Copy the code here: http://www.ozgrid.com/VBA/Sort.htm and follow the instructions in the middle of the page that begin: "To use this UDF push Alt+F11..."
115616
1. Open Microsoft Word\n2. Right Click on Toolbar\n3. Select CUSTOMIZE\n4. Select COMMANDS tab.\n5. Select FORMAT from left Column\n6. Drag SuperScript from Right Colum and drop it to Toolbar\n7. Drag SubScript from Right Column and drop it to Toolbar
1072460
Paste this macro into VBA\n(The >s represent tabs, please replace them. Tabs are really just for aesthetics, but help in macro troubleshooting)\n\nSub Del_Mt_Rows()\nDim lastRow As Long\nDim r As Long\n>lastRow = ActiveSheet.UsedRange.Row - 1 + _\n>>ActiveSheet.UsedRange.Rows.C...\n>Application.ScreenUpdating = False\n>For r = lastRow To 1 Step -1\n>>If Application.CountA(Rows(r)) = 0 Then Rows(r).Delete\n>Next r\nEnd Sub\n\nThen just run the macro and it will remove empty rows
258092
ctrl+alt  then arrow keys
1006477
back - backspace\nforward - alt+right arrow
763704
There are two options to handle the situation -\n\n1) Use Format > Cells > Alignment > Set Text alignment in vertical to Top & Text control to Wrap text, then readjust the row height to the normal height (instead of showing the whole contents)\n\n2) Create a column that only shows the first 5 characters of the A column - in B column enter formula =left(A1,5), then hide the whole A column now use the B column as the original A
317497
This may be overly symplistic, but if it were me, I'd open up both files at the same time and just link from one file to the other as if I were linking between worksheets.  That way excel creates the full path for you.  You could do that for one cell, then do a search and replace for all of the others.
674311
Don't know if this will help, but you can print only the odd or even pages.  See the print dialog box.\n\nYou could probably record a keystroke macro that start from the top of the last odd page, select all text on that page, delete it, skip to the top of the page twice (thus landing at the top of the next odd page), and repeat itself.  Run it on a copy of the file!!!\n\nIf someone around you knows VB, you definitely could get them to write a simple macro.
402884
Just go to D19 and hit Del button, the whole line will appear in full.\nReason is you got a spacebar entry in Cell D19, so its not showing on the formula bar and cutting the line start from A19 there.
845333
You don't even have to move to each cell.  Try this.\nIts unclear what you mean by grab the data but I'll put the values into an array.\n\nsub FindOpenCell()\ndim VarArray(10000)\nrowcounter = 1\ndo until cells(rowcounter,1) = "" \nVarArray(rowcounter) = cells(rowcounter,1)\nrowcounter = rowcounter + 1\nloop\ncells(rowcounter, 1).activate\n\nEnd Sub
79970
right click on cell, select format cell.
523331
You might consider linking an instruction to refresh the pivot table to the Excel event that is triggered when a user jumps from tab to tab. But this would only work if they could be expected to move around in the workbook and not remain on one tab.\n\nFor example, I inserted this code in each excel sheet object. When a user moves to a different tab, I have instructed Excel to refresh a particular PivotTable (which in my system is called "PivotTable2", and happens to be on "Sheet1".\n\nPrivate Sub Worksheet_Activate()\nSheets("Sheet1"). PivotTables("PivotTable2"). PivotCache. Refresh\nEnd Sub\n\n(The sheets refresh command is all part of one line - this yahoo screen may break it on to two lines!)\n\nIf you wanted to use this kind of trigger, then you would need to insert this coding on EACH worksheet object (not the modules of course). If you have many PivotTables that need to be refreshed, then you can write one macro to refresh them, and then call the refresh macro from the worksheet objects. (The refresh macro would be stored in a module.)
588815
This is a shot in the dark, but you may be able to write a macro using vb to create the key stroke. Good luck!
1185281
Goto Tools Menu > Macro > Visual Basic Editor (Alt + F11)\n\nType this in exactly...\n\nPrivate Sub Worksheet_SelectionChange(ByVal Target As Range)\n    Sheet1.Cells(1, 1) = Sheet1.Name\nEnd Sub\n\nSheet1.Cells(Row, Column)\nRow = Row Number\nColumn = Column Number (A = 1, B = 2, C = 3, etc)\n\nThis will change the text in the cell everytime you change the name of the sheet and click anywhere in the sheet.