Cut and Paste Data
Hi Experts,
I would like to request Experts help create a macro to cut and paste all data that were stars with "F00" at column B 1 cell up. E.g. Data at cell B56 need cut and paste it at cell C55. Same goes data at cell B79 moved to cell B78.
Hope Experts will help me create this feature. Attached the workbook for Experts perusal.
Cut-Copy-Data.xls
I would like to request Experts help create a macro to cut and paste all data that were stars with "F00" at column B 1 cell up. E.g. Data at cell B56 need cut and paste it at cell C55. Same goes data at cell B79 moved to cell B78.
Hope Experts will help me create this feature. Attached the workbook for Experts perusal.
Cut-Copy-Data.xls
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Correction:
Start the loop from second row:
because, there is no destination cell(i.e. C0), if B1 satisfies your criteria.
Start the loop from second row:
For i = 2 To maxbecause, there is no destination cell(i.e. C0), if B1 satisfies your criteria.
ASKER
Hi SANTABABY,
Thanks a lot for helping me.
Thanks a lot for helping me.
ASKER
Sorry if my question was not very clearly defined where should cut and paste the data. The data need to be pasted at the same column but 1 cell up. All other columns are actually with data, I simply remove it since it's not relevant to the question.