reformat

I have put together a very small sampling of test data to show what I am trying to accomplish, but am not 100% of how to go about putting this in action. We have a list of owners that pay a certain percent of margin of sales as a royalty payment. Which if it were just left at that it would be...

Hi everyone, I have been given a spreadsheet with just over 20000 lines of data, addresses to be exact. all formatted vertically in different cells e.g. A1Customer 12Address 13Address 24Address 35Address 46Address 57Tel8Web9Customer 210Address 111Address 212Address 313Address 414Address...

Hi I am very new to VBA basically copying bits from other workbooks so please bear with me! My query is as follows: I would like to reformat my output of <colgroup><col width="268" style="width: 201pt; mso-width-source: userset; mso-width-alt: 11434;"> <tbody> 12.9000299280694 -...

<tbody> Existing Data 600950 600951 600952 600953 600954 A 15 15000 300 B 200 1000 100 C 25 75 50 D 100 22 500 E 5000 80 F 750 15 600 G 100 1000 25 </tbody> Hi, Would someone help me write a VBA script to...

Hi there - I'm not sure how to go about this problem. I have an existing table of data that is in a format which is not very usable. I want to reformat the data in a manner that requires a little bit of coding, otherwise I'll need to do data entry and that will take a long time. Currently...

Hello, Today I have been given a task to reformat a massive, 36 sheet long excel file that has pretty messy organization. This is a screenshot of the original excel sheet: http://www.screencast.com/t/iVh0qWx5fCuk And this is how the formatting should look like...

Hello, I am curious about something. Is there a way that I can reformat columns based off of their headers? So for example, can I create a MACRO that says, If Header Equals UPC (That is, "UPC", "Upc", or "upc") than reformat the entire column so it is formatted as a "number" format as...

I have a sheet which shows date in first column then every 15min to the columns to the right (96 columns). This makes one row per day. I would like to get this sheet which has 365 rows for the year to display in two columns. First date/time, second is value. This would reformat the existing...

I am hoping someone can help me solve this formatting issue I have. I need to be able to take the data I receive in the following format: <tbody> John Smith (111) 111-1111 111 Any Road (222) 222-2222 Anytown, NY 11111 anyemail@anyemail.com </tbody> ...and convert it to this format...

Hello guys. I need a custom formula to make some reformating. The current format is as follows: AE.PR.04.484S or another example AE.EM.23.320s7 I need those to be reformated in 4484D and 23320s7 There is a huge number of Product codes but the format is the same.So the general rules are...

I have a excel master spreadsheet where sheet 1 contains a list of the residents in the subdivision. For example <tbody> L. Name F. Name Address Street Email Phone Children adam john & mary 123 main qwe@yahoo.com 999.000.8888 Mark Aray bill & sue 345 first asd@earthlink.com 111.222.3333...

Hey guys, So I've got an issue with a sheet that I have and it takes me a while to reformat it manually. This is how it is laid out Column A = Dates Column B = Germany Sales Column C = Denmark Sales Column D = France Sales Column E = Germany Price Column F = Denmark Price Column G = France...

I have a report of liquor license owners where each record takes 8 rows and 6 columns. Each data element has a tag in the cell immediately to the left of the data. all records appear to be structured the same: 3 rows, a blank row, 3 rows, two blank rows between records. How can I flatten this...

Hi, I have a database i've been working with and today I went to print the sheet and noticed that the sheet had many many blank rows. So when I went to print the table would not fit to the page correctly. Is there a way to re-format a sheet so that it eliminates all the extra blank rows?? I...

Hi, Please help I have worksheets that contains couple of records that I need to copy in another worksheet. Example: A --- B 1 AA1 ---01.01.2008 2 AA2 ---01.01.2008 3 AA3 ---01.01.2008 4 AA4 ---01.01.2008 5 6 7 BB1 ---01.03.2008 8 BB2 ---01.04.2008 RESULT: 1 TITLE ---DATE --- header 2...