Hi All,
I am completely new to vb-excel programming.I want to have a vb code which will open a worksheet(say A) and will loop through a range in A(range is having same column ) and based on the values in the cells, i want a new worksheet(say B1) to be opened and used range to be copied from that worksheet into my new main sheet(say C).
The value of next cell should open a new worksheet(say B2) and paste its used range right below the previous one in the main worksheet(C).
I guess its clear what code i want.
Any help is greatly appreciated.
Kp
What do you have so far?
What do you require help with?
Hi and welcome to the board
This is an Outlook forum but your question does not seem to be related to Outlook. is that correct?
Quoting entire posts clutters the forum and makes threads hard to read !
If you are pleased with a member's answer then use the Star icon to rate it
Click here to see forum rules
Thanks for responding.Originally Posted by davesexcel
Well basically what i require is a vb code for such a situation.
To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.
If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.
Doing this will ensure you get the result you need!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks