Hazarding a thought here

Assuming sample data as posted in Sheet1 and Sheet2,
running in A1 down

In Sheet1,
Put in B1: =A1+(Sheet2!A1/100)
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Amit Madke" wrote:
Consolidate Column Data From Multiple Worksheets into on 1 sheet
Comparing the values or showing percentage analysis of numeric data

Pls help me on this

Eg
Sheet 1
A - values
44
22
33

Sheet 2
A - Values
56
78
66

Consolidates data into 1 sheet
44 + 56/100 the value in percent

Using cell reference & dragging makes it difficult
Suggest me a easy way