dsmessenger
New Member
- Joined
- Jul 2, 2013
- Messages
- 5
Good evening all,
I have a two tab excel workbook. The first tab as a list of sequencial numbers (house numbers) in one column and a list of mulitple items across.
The second tab is editable and i want to freely input house numbers in say A1,A2,A3 etc.. and a item description against each in B1,B2,B3 etc... followed by a date required in C1,C2,C3 etc...
I want this information to automatically populate the first tab agains the correct house number and item. I assume this would be some kind of lookup against the number and the item description and populate the date.
The other sticky bit i'm struggling with is the second tab i need to be able to overtype the cells with other house numbers, descriptions and dates but it not change the data from the previous input.
i.e. table below typical input, this should populate tab 1 and then i can over type with say house 3 & 4 but plot 1 & 2 data remains in tab 1 and so on.
[TABLE="width: 500"]
<tbody>[TR]
[TD]House number[/TD]
[TD]Description[/TD]
[TD]Date[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Door[/TD]
[TD]18.06.19[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Door[/TD]
[TD]18.06.19[/TD]
[/TR]
</tbody>[/TABLE]
I assume all this will need some form of VBA macro to complete the task.
I have a two tab excel workbook. The first tab as a list of sequencial numbers (house numbers) in one column and a list of mulitple items across.
The second tab is editable and i want to freely input house numbers in say A1,A2,A3 etc.. and a item description against each in B1,B2,B3 etc... followed by a date required in C1,C2,C3 etc...
I want this information to automatically populate the first tab agains the correct house number and item. I assume this would be some kind of lookup against the number and the item description and populate the date.
The other sticky bit i'm struggling with is the second tab i need to be able to overtype the cells with other house numbers, descriptions and dates but it not change the data from the previous input.
i.e. table below typical input, this should populate tab 1 and then i can over type with say house 3 & 4 but plot 1 & 2 data remains in tab 1 and so on.
[TABLE="width: 500"]
<tbody>[TR]
[TD]House number[/TD]
[TD]Description[/TD]
[TD]Date[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Door[/TD]
[TD]18.06.19[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Door[/TD]
[TD]18.06.19[/TD]
[/TR]
</tbody>[/TABLE]
I assume all this will need some form of VBA macro to complete the task.