Re: At a complete loss for lookup/delete...

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

This should be fairly straightforward, but there are a few questions....

1. Would selecting an entry in the master bill summary be OK to choose what item should be deleted?
2. Is the item selected on the master bill summary unique, for example is there more than one car, if so what makes the entry unique?
3. How is the data entered into the monthly sheets, in the first place? I ask to understand the quality of the data on those sheets for the purpose of identification and matching to the summary data.
4. Do you wish to delete the entry from the master bill summary as well as all the other monthly sheets?
5. If you wish to keep the entry on the master bill summary, how do you wish to show that the item has already been deleted from the monthly sheets? Color the background for example.

--

Regards,
Nigel
nigelnospam@xxxxxxxxx



<bramnizzle@xxxxxxxxx> wrote in message news:388b2bd3-342e-4b41-b5d3-957b9e111d03@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I am getting a headache from trying to figure this out. Any help
would be greatly appreciated!

I posted this earlier...

Okay, here's a new one for everyone...

I want a macro (that I can assign to a button) that will allow the
user to select a cell and will delete that same cell from certain
other sheets.

For example...
on the *** "Master Bill Summary" there is a range of cells with
headings
B C D
9 Title Frequency Amount
10 Car ea month $410
11 Phone ea month $65

There are hidden sheets with the names of months (January, February,
etc.)
These hidden month sheets have this same information but start at row
12 on each of those sheets respectively.

For example...
"November"

(column A&B are merged)

AB C D
12 Car ea month $410
13 Phone ea month $65

There is information in cells E through I but that doesn't matter for
what I want.

I have a "Delete Bill" button on the "Master Bill Summary" ***.
What I want is that when the user clicks the "Delete Bill" button, a
box or something will open that will categorize column A (on the
Master Bill Summary ***) showing (for this example) 'Car' and
'Phone'...the user clicks a box next to one of the bills...say
'Car'...then the macro will find the row with 'Car' in column A (on
"Master Bill Summary") and delete the entire row and then go to every
*** with a month name, find 'Car' in column A and delete that entire
row.

Too complicated?

.

Quantcast