sivaprakasam
Member
Hi i am using the Excel 2013
In a sheet, all cell value come to the same column
Eg
This below in Sheet1 available
E1=3D SUMIF for multiple worksheets
F7=Dynamic lookup table with INDIRECT
E10=Count visible rows in a filtered list
E13=Sum visible rows in a filtered list
I13=Get address of lookup result
Requirement
To be changed in Sheet2
In a sheet, all cell value come to the same column (line by line)
A1=3D SUMIF for multiple worksheets
A2=Dynamic lookup table with INDIRECT
A3=Count visible rows in a filtered list
A4=Sum visible rows in a filtered list
A5=Get address of lookup result
Kindly provide the VBA
In a sheet, all cell value come to the same column
Eg
This below in Sheet1 available
E1=3D SUMIF for multiple worksheets
F7=Dynamic lookup table with INDIRECT
E10=Count visible rows in a filtered list
E13=Sum visible rows in a filtered list
I13=Get address of lookup result
Requirement
To be changed in Sheet2
In a sheet, all cell value come to the same column (line by line)
A1=3D SUMIF for multiple worksheets
A2=Dynamic lookup table with INDIRECT
A3=Count visible rows in a filtered list
A4=Sum visible rows in a filtered list
A5=Get address of lookup result
Kindly provide the VBA