Hi Chandoo.
I am looking for a makro that copies/transposes data from one workbook to another by checking headers and only copies/transposes data from specific columns. In the following example, I use “workbook2” and “workbook3”, but the makro should be accessible from all workbooks...
1. It would indeed be much easier to skip Workbook1 and work directly from the xml file. However, the xml is named after the client and the ParameterID/Resultnr/DisplayValue columns differs from client to client meaning the code has to fetch data from a column named "DisplayValue" instead of...
Here is a better explanation of the problem with workbooks attached.
Workflow:
1. Program data is outputted as .xml which is opened in Excel and transferred to Workbook1 day1. Workbook1 day1 measurements (DisplayValue) are then copied and transposed overwriting existing data (DisplayValue) in...
I really appreciate the time and effort you put into this work and I do apologize again. I'm new to VBA and continue to learn as we speak (hence no code attempt). This is also the reason for the new questions as I didn't know it was possible to create a VBA code this complicated.
The latest...
Hi Marc.
Your code works just as intended based on the workbooks that I uploaded and I do apologize for making this such a complicated matter. I hope that you will try to help me out one last time.
I have now uploaded the full workbook with all sensitive data removed (n/a). I need the code to...
It is basically just "copy and transpose" i'm looking for, but I need a code that applies to different outputs or days. See attached workbooks below with day1-3.
Day1 contains full dataset.
Day2 output is missing Display Value for Parameter C+D+E Resultnr. 1.
Day3 output is missing Display...
That is just what I have been looking for!
Will VLOOKUP also do the trick if I have 3 columns and want the search criteria to match both column 1 and 2?
Column 1: Parameter name
Column 2: Result nr
Column 3: Display Value
Is Vlookup able to differentiate between Parameter name "A" Result Nr...
Hi.
The uploaded workbooks are just examples and may be pre-formated by mistake.
Nothing needs to be created in Workbook2, just check for matching headers.
Does it matter where the code is located? If that is the case Workbook2 will be best.
If Excel basics can help me solve the problem...
Hi Chandoo.
I would like to copy data from Excel Workbook1 to Excel Workbook2 automatically. However, Workbook1 contains output data from another program which varies from day to day. This means that I need a code that transfers and transposes data matching column/row names (column "xx" in...