Hi folks
I need your help on excel file transformation. So, I want to create database table names which has been originally stored in excel file as provided below. Thus, I need VBA code to copy out the certain cells and paste them as a filename, sheet name, column name and as a row. The desired output is something like in the picture attached below.
I really appreciate your help guys, and I hope this answer to this thread can be also useful for users as well
Thank you in advance!
I need your help on excel file transformation. So, I want to create database table names which has been originally stored in excel file as provided below. Thus, I need VBA code to copy out the certain cells and paste them as a filename, sheet name, column name and as a row. The desired output is something like in the picture attached below.
I really appreciate your help guys, and I hope this answer to this thread can be also useful for users as well
Thank you in advance!
Filename | 1 Column Name | 2 Column Name | 3 Column Name | 4 Column Name | 1 Col Values | 2 Col Values | 3 Col Values | 4 Col Values | ||
Departments | Name | Num_Emp | Address | Backup function | HR | 5 | Wall street | yes | ||
I want this to be used as filename and sheetname | Column names | Row values accordingly | ||||||||