Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / November 2007

Tip: Looking for answers? Try searching our database.

At a complete loss for lookup/delete...

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
bramnizzle@gmail.com - 24 Nov 2007 00:48 GMT
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 sheet "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" sheet.
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 sheet) 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
sheet with a month name, find 'Car' in column A and delete that entire
row.

Too complicated?
Nigel - 24 Nov 2007 06:57 GMT
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.

Signature

Regards,
Nigel
nigelnospam@9sw.co.uk

>I am getting a headache from trying to figure this out.  Any help
> would be greatly appreciated!
[quoted text clipped - 43 lines]
>
> Too complicated?
bramnizzle@gmail.com - 25 Nov 2007 18:25 GMT
> This should be fairly straightforward, but there are a few questions....
>
[quoted text clipped - 10 lines]
> to show that the item has already been deleted from the monthly sheets?
> Color the background for example.
1.  I don't understand what you are asking here...Basically I want the
user to click the button and a list would come up with the items in
the Master Bill Summary.  The user clicks a box or whatever to select
that item and then clicks okay and then it proceeds with deleting.
2.  If a list comes up showing the contents in the master bill
summary, it shouldn't matter if there are more than one car.
3.  The data is entered by another button "Add Bill".  There are a
series of input boxes that come up which eventually populate these
cells.
4.  Yes, I want this to be deleted from the master bill summary as
well as the other month sheets.
5.  do not need this.

Thanks in advance!  This group rocks!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.