Problem In Excel, from time-to-time you may want to stack different columns of data into one column. For example, if cell A1 has the value of Bob, A2 has Jane, and B1 has Mary and B2 has Sue, you may want to collapse all the values from both A and B columns into one column. […]
Continue readingIf you want to convert a number to its equivalent letter, for e.g. 5 to E, you can use two approaches. 1. Insert this code in a Module and use this function ‘Author: Alan L. Lesmerises‘From: http://www.freevbcode.com/ShowCode.asp?ID=4303 Function ColumnLetter(ColumnNumber As Integer) As String If ColumnNumber > 26 Then ‘ 1st character: Subtract 1 to map the characters […]
Continue readingExcel Watch: An Official Excel Blog: “Probably the most common question the Excel team gets from our customers is ‘when are you going to add more rows/more columns/more rows and more columns’… Well, the answer to the question is ‘in Excel 12.’ Specifically, the Excel 12 grid will be 1,048,576 rows by 16,384 columns. That’s […]
Continue readingCreating scatter plots in Microsoft Access is a challenging problem. Follow these steps to create your own scatter plot: Under forms tab, click New On the New form window select Chart Wizard and Select the table, which has your data, hit OK On the next screen, add two fields for which you want to plot […]
Continue readingUsing this code you can add the same footer to all the worksheets in your workbook. It’ll ask you for Left, Center and Right footer. Please note that if you want to print all the worksheets with continious page numbers you’d have to select all the worksheets at the same time. This code will do […]
Continue reading