manipulation

  1. P

    Manipulating named sequential Option Button properties

    I have developed a search function within Excel. There can be multiple results. The results are listed on a page. I would like to be able to: 1. Create the number Option buttons according to the number search results 2. Make the Option buttons visible. Alternatively, I have created 100 Option...
  2. S

    Help with data manipulation

    Hi I have imported some raw data on sales and need to manipulate it so that i have 1 column for Date, 1 for sales and 1 for quantity. So i'm trying to create a macro that inserts new rows, inserts 3 new columns "date,sales,qty", then transponses my values down. I've made a demo spreadsheet...
  3. T

    How does one enter in two variables, both of which have to corrected, to get an answer?

    Hello, I am attempting to speed up the process by which we calculate weight percent of sulphuric acid based off specific gravity and temperature. The issue I am having is, the values given in the charts we have are not exact, therefore we have a hand-written equation that is tried-and-true...
  4. Living

    Extracting and Manipulating Text from Cells.

    Hi, This could be a bit complicated, but hopefully also useful for others. We have the following sample of 10 cells from a large file with similar data: N: 1; B: 162; M: 278, 278; T: 24; A: 103, 105; I: 393; Ḥ: 7240, 7390, 7465, 7546, 7617, 7756, 27399, 8380, 8741, 8894, 8985, 9559...
  5. J

    What are the equivalent keywords to perform string manipulations?

    Hi all, I want to convert a sentence (stored as a string variable) from the present tense to the past tense but I'm having trouble locating the relevant string manipulation commands to accomplish the task. Does anybody have any idea how I could do this within my current code (shown below)...
  6. G

    Split Column based on contents

    Hi I did a query using VBScript to gain some server info and now have a text file in the following format \\servera\ dog cat mong \\serverb\ dog cat mong ming \\serverc\ What I am looking for is a clever macro to move the rows relating to each server to a new worksheet eg tab1...
  7. D

    manipulate list of data into separate columns

    Hello, I am using Excel 2007. I have a list of data that I am trying to parsed out intto separate columns depending on criteria in the first column/list of data. Example data: <table style="border-collapse: collapse;" border="0" cellpadding="0" cellspacing="0" width="477" height="741"><col...
  8. K

    Copy data from rows to columns based on criteria

    I recently posted a thread whereby I have a listy of 15,500 entries of policy numbers and the funds invested in these policies. However each seperate fund had a seperate row on Excel (i.e. a policy with four funds had four rows on Excel). What I have been trying to do is have one row with...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top