Insert values from one sheet to another with a Loop

**acsishere** · 10-05-2008, 02:22 AM

Dear Friends,

I need to insert values from a column in one sheet to another sheet with a Loop mentioned here.

(I have attached a sample workbook for your kind reference.)

IN STATEMENT SHEET, I NEED TO INSERT (IN col F) THE VALUES from Col A of NOS sheet.THE INSERTION SHOULD BE LOOPED AS MENTIONED HERE

i.e. First time, it should be 1 to 10
Second time it should be 2 to 10 and 1
Third time it should be 3 to 10 and 1, 2
Fourth time it should be 4 to 10 and 1,2,3
Fifth time it should be 5 to 10 and 1,2,3,4 …. And so on, till the last row with a value in ColA.
THE VALUES IN Col A of NOS Sheet MAY BE CHANGED WHENEVER REQUIRED. There it is 1 to 10, but it may be Alphabets or any other words also.
Hence, whatever values in Col A of NOS sheet should be taken for looping.
I hope some one will help me to find the solution through VBA.

Thanks in advance.

acsishere.

**royUK** · 10-05-2008, 03:13 AM

I haven't a clue what you mean!

**Mallycat** · 10-05-2008, 03:24 AM

and why have you chosen to call your sheet Q14.xls?

**ravishankar** · 10-05-2008, 04:22 AM

Hi
Try the macro in the attached file
Ravi

**acsishere** · 10-06-2008, 02:49 PM

Yes Sir, you got it. In fact it is almost 99% done.

When I run the code I am facing only one problem. i.e. in NOS sheet the number of rows should be 10 as per the macro. But, I need that if I enter 1,2,3,4 and 5 it should be looped as mentioned.

I have clearly mentioned the problem(s) in the sample workbook attached with this post.

Please Sir,

Thanking you for your help.

acsishere.

**ravishankar** · 10-07-2008, 03:03 AM

Hi
The attachment has modified macro. Not sure where you want complete set of 5 nos and where blanks start appearing.
Ravi

**acsishere** · 10-07-2008, 10:35 AM

Dear Sir,

Thanks for your continuous support. Still, I need your further support to get the program as it is required.

Sir, I have once again mentioned the modifications in BOTH NOS sheet & STATEMENT sheet. (Attached the sample file).

Please Sir, help me to find the soultion.

Thanks in advance.

acsishere.

**ravishankar** · 10-07-2008, 01:46 PM

Hi
try this modification
Ravi

**acsishere** · 10-11-2008, 09:17 AM

Thanks a lot for your solution & continuous support.

This is the ultimate solution.

Again, thanks, thanks a lot.

acsishere.

Insert values from one sheet to another with a Loop

LinkBack

Thread Tools

Rate This Thread

Display

Insert values from one sheet to another with a Loop

macro

Dear Mr. Ravishankar,

modified macro

Dear Sir,

modified macro

Dear Sir,

Thread Information

Users Browsing this Thread

Similar Threads

auto insert column when sheet is opened

VBA; find string and copy

copying cell values to specific area in sheet

Lookup data on specific sheet and cell when I type Sheet name in...

Match 2 values from one sheet in another sheet.

Bookmarks

Bookmarks

Posting Permissions