Fill down to last cell containing data

[Courtneydog]

Hi
I am sure this is probably a quick fix but I can't get my head around the solution.

I have the following code:

Please Login or Register  to view this content.

What I need to do is to continue to fill down until " " (or a null value) is found within A*:D*


Please can anyone help me ?

[TMS]

Maybe:

Please Login or Register  to view this content.

Regards

[Courtneydog]

Thanks for that.


I am not sure why, but this only brings in the first 3 records.

[Courtneydog]

Hi I am struggling with this question.

TMShucks gave me a solution (thank you) and after solving my own coding error (just row numbers) , I now have that bringing in the first 4 rows of data, but no more.

My (revised) vba is thus:

Please Login or Register  to view this content.

My problem is that the worksheet "Import" has approx 30 rows (varies) and I need to bring them all into the "Export" sheet.



Any help very much appreciated.

[TMS]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

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!

[Courtneydog]

Humble apologies. Rules digested.

Explanation:
I have (had) a working spreadsheet which took a csv from my bank, processed the data and prepared it for export to MS Money.

My bank have decided to separate two previously joined data streams and I now need to concatenate transaction type and description into one field. I have done this by outputting concatenated results to a second worksheet (Export)

All I need to do now, is get the Export sheet, to reflect all of the rows within the Import sheet. At present, I am only getting visibility of the first three rows.

I hope this makes sense.

I have attached the csv (as xls) from the bank (with dummy data) and my spreadsheet.

Many thanks

[TMS]

Please fix the Code Tags, as requested ... in both the posts with code extracts.

Thanks

[Courtneydog]

Please fix the Code Tags, as requested ... in both the posts with code extracts.

Thanks

Tags added as requested

[TMS]

Thanks for fixing the code tags.

Amended code:

Please Login or Register  to view this content.

Output:

The output starts in row 3; I trust this is what you want.

Regards, TMS

[Courtneydog]

Fixed - many, many thanks

[TMS]

You're welcome.


If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save