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
You need to give a lot more detail how this is meant to work.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
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.Originally Posted by mdmackillop
anyone can help me regarding this case?
Posting Permissions
Reply With Quote