Category: Excel
Formula to count the blank cells in excel
- 0
When I was working on some data calculations in a excel sheet, we had a situation to count the blank number of cells in a range of rows. There are lot of statistical formulas available in excel Here is the one formula which can be used to achieve this. and We can see how can use…
Read More
Copy from one workbook and paste into another
- 0
One of my friend was trying to copy the data from one work book to other workbook. We can automate this using the VB macro. Here is the solution for it: I have a work book “test1.xls” which has some contents as shown: You can download it from here: test1.xlsx And I have another workbook…
Read More