ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   please help in this program (https://www.excelbanter.com/excel-discussion-misc-queries/133265-please-help-program.html)

TheGodfather

please help in this program
 
In a new sheet go to A1 and enter the value 1. In A2 enter the
following formula:
=IF(RAND()<0.9,A1,A1+1)
Copy the formula down until A30. The result will be groups of
increasing numbers. Select the entire column, Copy, Paste Special...
Values only, to stabilize the data.
Class Libraries
Task 1
Write a VBA macro to go down the list in column A:A. Every time a new
group starts, an empty row should be inserted to distinguish between
groups.
Task 2
Write another VBA macro to also insert a row before the first group.
Each inserted cell should now not be blank by say: Group X where X is
the number of the group that is following.

THATS THE PROBLEM , IF U PLEASE POST ANY HELP, IN VBA OF COURSE, THE
PROGRAMS SHOULD RUN FROM VB



All times are GMT +1. The time now is 09:22 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com