Macro help

chef

Well-known Member
Joined
Jul 10, 2002
Messages
610
Office Version
  1. 365
  2. 2016
Hi,
forgive as Im just starting to look at macros

I have recorded a macro and saved as a personal macro and wonder if i could add to it

or even run a separate macro

I have a sheet called master where I run my marco but I have 2 other sheets, one called starts and one called leavers.
I have an indicator of 1 in each of these sheets in column D

I would like to automatically go to the start sheet then the leaver sheet and I want to be able to delete each row, out of 14000 records, anything that has an indicator of 1 against the record.

is this possible?

regards
 

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.
Hallo

Complex but can be done, you have to describe in detail all the required fields and leaves the flow of data required.

A resent with technical information
 
Upvote 0
Hi

What I am trying to do if figure a way of running a macro down column D and if there is a value of 1 in the cell, delete that row.

regards
 
Upvote 0

Forum statistics

Threads
1,224,591
Messages
6,179,767
Members
452,940
Latest member
rootytrip

We've detected that you are using an adblocker.

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.
Go back
Back
Top