Replies

I want the popup form to open up to the current record on the calling form.

Works perfect!! Thank you so much.

Dan……………….. who will one day get the hang of VBA

I want to thank you both for your help. I also purchased John’s book. So far it has been helpful. This is what I pieced together:
Worksheets(“GLLINK”).Range(“A1000”).Activate
ActiveSheet.UsedRange.Select
MsgBox Selection.Count / 5

For x = 1 To Selection.Count / 5

ActiveCell.Offset(0, 2).Range(“A1”).Select
ActiveCell.FormulaR1C1 = “100”
ActiveCell.Offset(0, 1).Range(“A1”).Select
ActiveCell.FormulaR1C1 = “=MID(RC[16],2,8)”
ActiveCell.Offset(0, 1).Range(“A1”).Select
ActiveCell.FormulaR1C1 = “=MID(RC[15],11,5)”
ActiveCell.Offset(0, 10).Range(“A1”).Select
ActiveCell.FormulaR1C1 = “GL”
ActiveCell.Offset(0, 3).Range(“A1”).Select
ActiveCell.FormulaR1C1 = “=RIGHT(RC[1],4)&LEFT(RC[1],4)”
ActiveCell.Offset(0, -6).Range(“A1”).Select
ActiveCell.FormulaR1C1 = “=IF(RC[10]=””D””,RC[9],””-“”&RC[9])”
ActiveCell.Offset(1, -11).Range(“A1”).Select

And it works just fine. The only issue I have now I have to remove certain rows before I can move this data. The first column is my accounting unit…is there a way to to have the macro delete the rows where a cell in Coloumn begins with 160.xxxxx or what have you?? I have it deleting empty rows and moving them up but I have had no luck in having it Identifying a variable number in column A and removed the whole row like a blank row.

Any ideas??

Dan

Not confusing at all. All this info has been helpful.

Thank you.

Dan

Great help thanks so much.

But I went a bit crazy and cannot figure out how to show the tools menu again so I can change some items on the startup. Anymore suggestions?

Dan

No, I have imported it several times now.

Dan

Thank you for your response. I’ll try to explain a bit better. If in the cell b115 I have 114. I set b12 to = b115 I ahve 114 in b12. If I copy the formula in b12 to b13 I get nothing in b13 unless I go in and manually type =b115. It seems as if when it gets copied it loses its association.

Hope this is clearer.

Dan

Thank you very much.

Dan

Thank you very much for your help. I am trying to get into the VBA side of Excel as to maximize its use. Can anyone point me to a good training web site with examples or a good book so I do not bother you folks with a lot of basic questions??

Thanks for your help.

Dan