I need some help with a bit of code i'm trying to write. I am not very experienced in VBA, I thought a VLookup is what i needed but after thinking about it. I think a Find loop with work even better.
There will be a button click on sheet1.
The code will need to do the following, in sheet "Global" use column B and search range, each row will have a different value, it will need to search the cell value row by row, in Sheet "Details" if match found then copy the data from columns H, F & E and paste into columns O, P & Q in the Global sheet. H = O, E = P, D = Q. Loop through until first empty row.
In the Details sheet, in column B if there was no data matching from Details then the row will get deleted.
For Example:
Global Before:
Details Before:
After Code has run:
Global After:
Details After:
Hopefully this explains it well enough, as you can seen it has found the matching data and copied it to the relevant rows, all non matching data has been deleted.
I have no code at the moment because if i honest i have no idea where to start!!! All help is much appreciated!!
There will be a button click on sheet1.
The code will need to do the following, in sheet "Global" use column B and search range, each row will have a different value, it will need to search the cell value row by row, in Sheet "Details" if match found then copy the data from columns H, F & E and paste into columns O, P & Q in the Global sheet. H = O, E = P, D = Q. Loop through until first empty row.
In the Details sheet, in column B if there was no data matching from Details then the row will get deleted.
For Example:
Global Before:
Details Before:
After Code has run:
Global After:
Details After:
Hopefully this explains it well enough, as you can seen it has found the matching data and copied it to the relevant rows, all non matching data has been deleted.
I have no code at the moment because if i honest i have no idea where to start!!! All help is much appreciated!!
