VBA to find next blank row

[kenadams378]

Hi,

I'm struggling with a macro, i have 2 data sources that i need to copy into one tab, copying the data from the first tab is fine but i need to add a line of code before copying the 2nd tab to find the next blank line after the 1st tab of data?

Hope that makes sense?

Code is currently

Please Login or Register  to view this content.

[patel45]

you can find the last used row with

Please Login or Register  to view this content.

then the first blank is

Please Login or Register  to view this content.

[kenadams378]

If i add these to the macro will it copy the and paste the data in the next blank row?!

[patel45]

FBR = Cells(Rows.Count, "A").End(xlUp).Row + 1 return the number of next blank row, as you asked

[kenadams378]

Thanks you, sorry if my understanding is incorrect.

As part of the macro, i want it to select the next blank row after the previous data has been copied in then continue to format and paste the extra data in as per the code i have posted.

[patel45]

If you are not able to change your code attach your file for testing

[kenadams378]

Attached as requested

Appreciated

[patel45]

what do you want get with

Please Login or Register  to view this content.

[kenadams378]

I'm not sure i didn't record the macro but i assume it is selecting the data from that sheet?

[patel45]

attach your file and describe what you want

[kenadams378]

File is already attached

[patel45]

ok, File is already attached, but you did not explain your goal, forget your macro.

[kenadams378]

Ah ok.

Using the data from the GI B2 TB & GI C2 TB tabs i want to populate the GI Data tab with both sets of information.

The macro i currently have formats the data and will populate the table buti want to paste the GI C2 TB underneath the GI B2 TB on the Gi Data tab.

[kenadams378]

Any luck with my detail above?

[kenadams378]

Have you found a solution to this at all?

[kenadams378]

Is this something you can advise on? I need to workout code to copy & paste in the next blank cell??

[patel45]

From forum rules
If your question has not been answered within a day, consider adding another post with any additional information you believe is relevant. If you think your post is good as is, just reply to your own thread with the words "Bump no response", which will bring it to the top of the forum.

can you add a sample of Gi data filled ?

[kenadams378]

As requested, filled 'Gi Data'

The code would find the next balnk cell which would be column A cell 865

[patel45]

Ther'is no sheet 'Gi Data' in the attached file

[kenadams378]

Sorry the sheet name is incorrect, the sheet name should be GI Data

[patel45]

check please the attached file

[kenadams378]

I can't see your attached file?

[kenadams378]

I've attached my file again

[kenadams378]

"Bump no response"

[patel45]

in the first post you attached a macro with this line

Please Login or Register  to view this content.

then you have a sheet named GI Data in your workbook, I'm waiting for you to attach the entire workbook

[kenadams378]

Ah sorry i wasn't aware you wanted the full workbook...

The workbook is over 4mb

[patel45]

I don't need all data, I need to see the structure, then all columns but 20 rows a sheet

[kenadams378]

Structure as requested

[patel45]

I don't need all data, I need to see the structure, then all columns but 20 rows a sheet

sheet 'Gi Data' is empty.
I'm sorry, but I can not make myself understood by you, now I stop.

[kenadams378]

Do you need to see 20 lines of data on the GI Data tab?