Add values based on query

Closed

Sanjib - Jun 14, 2010 at 01:07 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 14, 2010 at 05:00 AM

Hello,

i have data in various sheets in excel which i want to add in summary sheet based on query. for exam. i have sheets named B1,B2,B3,B4,B5
& Summary Sheet. In Summary Sheet when I enter B1 TO b4 i must get the addition of Sheet B1+b2+b3+b4 and so on. i will appreciate ur help on this.

Based on the values in cells b77 b81
Code to move rows into another sheet based on certain values ✓ - Excel Forum
Excel macro to create new sheet based on value in cells - Guide
Instagram account based in wrong country - Instagram Forum
Insert picture in Excel macro which takes the file name refrence - Excel Forum
Based on the values in cells b77:b81, what function can automatically return the value in cell c77 ✓ - Excel Forum

1 response

Answer 1 / 1

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 14, 2010 at 05:00 AM

Could you please upload a sample file with sample data etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too

Similar discussions

help me to add particular cells

Fill adjacent cell with number from text answer

Excel function question

Return Seq Values Until Blank value then return different set of seq values

Clear cell contents based on value of another cell range using VBA

Similar discussions

Subscribe To Our Newsletter!