I am new to this forum. First of all i wish to thank the creators of this forum. The forum can help many who are interested to learn excel.
MY QUERY: I am working 4 sheets: sheet1: master_sheet sheet 2: A Sheet 3:B Sheet 4:C

Sheet 1 Name: Chk_ List (Master Sheet). This has the 4 coloumns and 35 rows
A1: A35 has description C1:C35 has description
B1:B35 data to be entered by the users D1:D35 data to be entered by the users

Now this data has to be copied partially in sheet 2,3,4

For example rows b1-b10 from master sheet in sheet 2--
Rows b11-30 from master sheet in sheet 3
Rows B30-B35 & D1-D35 from master sheet
desc in rows a and c is already done when sheet ,2,3,4 are created

Users will have their own files on their desktop or a common drive and they will copy and paste the values from B and D Rows in sheet 2,3,4 to a particular application which the company uses commonly.

Main objective is to enter data one time in chk list and copy it in the required places on the office software. Sheet 2, 3,4 represents the same description which we use in our office software. Basically i am taking the help of excel to fill the data thorough copy (ctrl+c) from sheets 2,3,4 in our office software/application and hide any formulas which are present in the cell. Formulas like for addtion in two rows into 1 in the next sheet, concatenate text in tow three rows into one in the next sheet.

Can i do this with out vba code where i can hide the formulas and users can just copy the results from sheet 2,3,4 in to the required application


Sorry if the query was too long . Just want to query what i wanted clearly

You can email me in case of any further queries, hints, tips,answer MY Email id is : [email protected] .------ Many Thanx