Forum Discussion
Excel Data Import with custom formating rules
Hello i want to copy-paste data from one workbook in to another work book based on specific custom cells range and then paste in to another sheet to push to database and for internal record. The prob...
Yea_SoHello Below is the attached workbook, so i want to import data FROM sheet2 in to Sheet1 using some recorded Macro to automate the manual copy-paste and typing abbreviations such as "D" for Decrease and "1" for True and "0" for False. Thanks in advance for any help or ideas or suggestions given in this regard .
Hi nidospartan
Here is the edits I did to your workbook:
Your sample data:
Converted data using excel formulas:
Data moved Destination Form using UNIQUE Funtion:
All you have to do is copy and paste to the Source Data Sheet, and it will automatically convert the data based on the Look up Sheet which you can edit/add they're dynamic tables so the range will autoadjust when you add items:
Let me know if you have any questions