AbdulkareemAlhassni
New Member
- Joined
- Nov 16, 2018
- Messages
- 41
Hi there,
how can i make a condition to copy then insert a column to another workbook,
the only condition is that, if this columnd header exists in the current workbook dont copy it !
EXAMPLE:
workbook1
[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Age[/TD]
[TD]City[/TD]
[TD]Email[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Workbook2
[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Title[/TD]
[TD]Age[/TD]
[TD]Salary[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
so when i copy from "Workbook2" to "Workbook1" ==> i will get
New Workbook1
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]Title[/TD]
[TD]Salary[/TD]
[TD]Age[/TD]
[TD]City[/TD]
[TD]Email[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
hope am clear
thank you.
how can i make a condition to copy then insert a column to another workbook,
the only condition is that, if this columnd header exists in the current workbook dont copy it !
EXAMPLE:
workbook1
[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Age[/TD]
[TD]City[/TD]
[TD]Email[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Workbook2
[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Title[/TD]
[TD]Age[/TD]
[TD]Salary[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
so when i copy from "Workbook2" to "Workbook1" ==> i will get
New Workbook1
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]Title[/TD]
[TD]Salary[/TD]
[TD]Age[/TD]
[TD]City[/TD]
[TD]Email[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
hope am clear
thank you.