combining data

  1. R

    Creating Email Addresses for Blank Cells

    I have a spreadsheet that has 4 columns - Company Name, First Name, Last Name, Email Address The first 3 are complete. the 4th, Email Addresses has blank cells. Two issues: How do I create a valid email address for the blank cells using the information in the cell above? Also, is it...
  2. M

    Extracting and categorizing Data from 15 different workbooks

    Hi I’ve got quite a complex problem to solve and I’m not even sure if this can be resolved with VBA? Maybe some of you can look at it and give me some ideas. Unfortunately I’m not really familiar with programming I will however try to modify certain codes if necessary. <?xml:namespace prefix = o...
  3. S

    Can excel copy data from different rows on multiple worksheets into one?

    I have Excel 2010. I have read multiple solutions about combining multiple workbooks containing multiple worksheets into one. The problem is that each worksheet has well-defined data in cells A1 thru G100. Well, I dont have that. I have data that starts in various cells on each WS (a100:F250 on...
  4. R

    Merging Flow Data

    Some colleagues and I can't quite get this one. We have some travel flow data between places such as: A B 40 B C 50 F Y 9 B A 2 T R 65 Y F 33 Each of the end points (A, B, etc) is in a column, and then the third column is the number of people that moved between those points. What we need to...

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
Back
Top