data migration

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...

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...

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...

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...

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...

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...