prakashtoosmart
Nov 14, 2012, 04:21 AM
Dear all,
I import sum p&l acc details from tally to excel sheet 1. but I want to get results in 2,3,4th page in 3 headings. What is the formula/procedure to get the results. Thanks...
JBeaucaire
Nov 15, 2012, 08:56 AM
There's no simple answer to a vague question like that. Data can be transferred from one sheet to another in so many ways...
It can be done with formulas like VLOOKUP or INDEX/MATCH if the data on sheet1 is used to update specific rows on the other sheets.
It can be done with VBA if you simply want the data specifically copied to the other sheets enmasse based on some criteria you have yet to explain.
Best attach a sample workbook showing all these sheets with good sample data if you want specific suggestions.
Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook.