Inputting data in in a tab and recording to another

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.
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Forum statistics

Threads
1,223,893
Messages
6,175,249
Members
452,623
Latest member
Techenthusiast

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top