formatting data

I am trying to format a large amount of data that comes up like this... 1 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 2 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 .... I would like to have the bold numbers going down a single column. The remaining numbers i would like to...

Hello, I'm creating a user form in excel. I have one cell in which the inputted data needs to conform to strict guidelines (it's an account number field). What I'd like to do is use vba to validate the cell content immediately after it is entered (e.g. as soon as focus is shifted away from...

I have "inherited" several reports for Excel 2010 where the data is generated via VBA but the formatting of the reports, including borders, merged cells, font styles, etc were manually added to the sheets. I wish to replicate these formatted characteristics into the VBA modules that create the...

Greetings everyone, I have 2 spreadsheets that I'm using...one is to cut data from and the other is to paste data into. I am transferring 2 columns of numbers with each column having about 200 rows, between the spreadsheets. I am only trying to sum these 2 columns together, but for some...

Hello everyone! I'm tying to automate something relatively simple, but I am getting my butt handed to me. I need to underline text which is populated from a formula. The formula is quite simple but the formatting is killing me. I know how to format numbers, dollars and dates within a...

Hi there, I have a spreadsheet which has been awkwardly formatted by a client with over 50,000 rows. I've tried creating my own macro to automate the work but it just won't seem to work (i'm probably missing something obvious). At the moment the data looks like this...