PDA

View Full Version : once data input for 2 sheets in different table structure



mtsf26
11-17-2011, 07:30 AM
if i have 2 sheets with different table structure then i need to take some data from one sheet and put it on another sheet.is it possible to do that automatically using vba or function?so when i type it in sheet A then sheet B will be filled up with the same data too but in different table structure.i have attached the file too.i gve different colour to refer the source.thanks in advance

mdmackillop
11-17-2011, 04:49 PM
You need to give a lot more detail how this is meant to work.

mtsf26
11-18-2011, 01:58 PM
You need to give a lot more detail how this is meant to work.
from that table, let say im going to get data for Tanggal in sheet1(B2) so in sheet source i should write the date in cell AB5 and if i want to get data Sortimen in Sheet1(J2) i should write the data in Sheet source (T1). As u can see they have the same color for sheet1 and sheet source,if im talking about Tanggal,so between source and sheet1 have pink color.the color just to make us easier to understand one cell in sheet1 refer to one cell in Source sheet.

mtsf26
11-23-2011, 09:00 PM
anyone can help me regarding this case?