I have data from A1:D512
In A col i have ID.... followed by numbers (eg; ID65498711, ID65498715 etc) between every id there is a gap of like 15 - 20 row etc. please see table below.
I want the macro to delete 4 next whole row;
eg if A1 has ID6542122; I want the macro to delete row A2, A3, A4...
Macro help please
In a sheet1, range A1 to D1000 has datas...including customers account number. I want the macro to replace all the account number with dats.
I want all the numbers no matter what kinda number it is from 1-10 replace it with dots...
Please design a macro...
Thanks again!
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.