Hello I’m Bill
I’m trying to write a VBA code to transfer data from a spread sheet to a form by using a if function. I want it to move the data when I post the date in the form A7. I have a spread sheet with 500 rows and 13 columns. I want to move curtain data into the form. And there are some blanks in the spread sheet. This will give you a idea what I’m trying to do.
If cost A6:A500 has the date that enter in the form, then If C6:500 has a code of 50040 it should copy over B E F G K in form .B copied into Form A15:A26, E copied into Form E15:E26, F copied into the formF15:F26 G copied into the formH15:H26, K copied into the formI15:I26 and have it loop until it get a empty cell in the form or fill up row 26.
If cost A6:A500 has the date that enter in the form, then If C6:500 has a code of 50000 it should copy over B D E F G K in form .B copied into Form D2840, D copied into Form B28:B40, E copied into Form G28:G40, F copied into the form H28:H40 G copied into the I28:I40, K copied into the form J28:J40 and have it loop until it get a empty cell in the form or fill up row 40.
Thank for your help on this
Bill
I’m trying to write a VBA code to transfer data from a spread sheet to a form by using a if function. I want it to move the data when I post the date in the form A7. I have a spread sheet with 500 rows and 13 columns. I want to move curtain data into the form. And there are some blanks in the spread sheet. This will give you a idea what I’m trying to do.
If cost A6:A500 has the date that enter in the form, then If C6:500 has a code of 50040 it should copy over B E F G K in form .B copied into Form A15:A26, E copied into Form E15:E26, F copied into the formF15:F26 G copied into the formH15:H26, K copied into the formI15:I26 and have it loop until it get a empty cell in the form or fill up row 26.
If cost A6:A500 has the date that enter in the form, then If C6:500 has a code of 50000 it should copy over B D E F G K in form .B copied into Form D2840, D copied into Form B28:B40, E copied into Form G28:G40, F copied into the form H28:H40 G copied into the I28:I40, K copied into the form J28:J40 and have it loop until it get a empty cell in the form or fill up row 40.
Thank for your help on this
Bill