data migration

  1. D

    Data migration between sheets

    Hello, I am stumped. I am trying to come up with code that migrates data using VBA. below i will share some screen shots to hopefully describe the situation better. So this first two pictures are sheet1 and the data points i want to move to sheet2 which is the third picture. The way it works is...
  2. D

    Extracting data from current workbook to another workbook using file path that is in a cell

    Hello, 1. using VBA, i am trying to think of a way to copy values from a whole column in workbook1 worksheet "sheet2", starting from column F on sheet2 and X number of columns to the right and paste the values into another workbook, lets call it workbook2, and the worksheet the values will...
  3. A

    Copying closed workbooks to a new workbook

    I need to be able to have individual sheets from different WKBKS to link data to another WKBK which is my dashboard. What I am trying to achieve is I need is to be able to open all WKBK'S in a Folder automatically and import the data, sheet1 from each WKBK so that the sheets copied will...
  4. S

    Need help combining large tables of data

    I’m in the process of transferring a database of client records from an old Access-based database program to a new database program. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p> The new program will only accept .csv import files. I can export those...
  5. V

    How to insert data from comma delimited file

    Hello: Im a web programmer that never used excel. I have a new customer who is an accountant and who with excel he designed himself an accounting processing application. He wants me to make an online tool to capture data he needs from his customers and this data I will be supplying to him...
  6. S

    how to tranform data in Access - urgent

    I have a big data in the following format (Headings) ProjectID ; Jan ;Feb (Data row 1) A; 1 ; 2 (Data row 2) B; 4 ;Null I want to transfer this data in the following...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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