Macro To Insert Rows Based On Inputs

September 28, 2015 at 04:38:29
Specs: Windows 8
A bit Complex question:-
If AK3 to BM3 is having number such as 1,2,3...
then it add new rows depending on the above inputs. the numbers can be in more than 1 cell.
Also A3 will be the value coming from AK2 to BM2
depending where it will get the numbers from AK3 to BM3.
Hope you are able to get my question.
need a macro please.

message edited by Mk


See More: Macro To Insert Rows Based On Inputs

Report •


#1
September 28, 2015 at 19:59:10
I don't understand what you are trying to do.

You say your numbers (1,2,3..) are in Row 3, from Column AK through BM.

Then you say "it add new rows depending on the above inputs."

Where are these rows supposed to go?

"Also A3 will be the value coming from AK2 to BM2
depending where it will get the numbers from AK3 to BM3."

I have absolutely no idea what you mean by that.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
September 28, 2015 at 23:42:47
Really Sorry for the confusing question..
Cells AK3 to BM3 is having number such as 1,2,3...-->Correct
Actually a macro is needed to insert a row below row 3.
If we find a value for example in cell AK3 is 1, a row will be added. similarly if it finds 2 in AK3 cell, 2 rows will be addded below 3rd row. 3 rows for 3....
The numbers can fe found from Cells AK3 to BM3
Also A4, (i.e fourth row added by macro if number 1 is found in Cell AK3) will be coming from the AK2(This will be fixed).
I have nearly 2500 rows to do the same.
Doing manually takes a hell of a time.
If you want I can send the spreadsheet if you provide any email address.
it would be really helpful if the macro is provided.

message edited by Mk


Report •

#3
September 29, 2015 at 04:52:35
Please post the spreadsheet at a share site (zippyshare, a Google Drive, etc.) and then post the link back here.

Please do not use a share site that forces us to register. We won't.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions

#4
September 29, 2015 at 05:24:05
please find the link below..

https://drive.google.com/file/d/0B2...

Thanks in Advance.
Regards.


Report •


Ask Question