LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default Automating adding/deleting rows and content with macros (I suppose

Hi all, I currently have three tabs on my Excel file, say "output1",
"output2" and "database" in which information in the database tab will appear
in the output tabs.

Each row of information in the database tab will span a single row, and a
number of columns. All such information will appear in only one of the two
output tabs.

Currently, whether such information appears in output1 or output2 depends on
the formulas in the respective output tab. If output1 contains formulas that
refer accordingly to the database tab while output2 doesn't, then the
information would only appear in output1 and not output2.

What I'd like to do is to add two checkbox (output1 and output2) sections in
the database tab, so that a) I can eliminate the manual component of writing
the formulas in the different output tabs, and b) automate the whole adding
(and deleting) process in the database tab simply by checking (unchecking)
the right checkboxes.

Any help would be much appreciated. Thanks!!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Deleting Rows - only deletes content Phil Excel Discussion (Misc queries) 2 March 12th 10 04:43 PM
Automating deleting rows Alice Excel Discussion (Misc queries) 2 March 10th 08 06:35 PM
Help on deleting rows using Macros ashel Excel Programming 2 October 5th 06 10:01 PM
Help - Automating a file.. Adding Users , Deleting users, Changing Tim Harding Excel Worksheet Functions 0 March 16th 05 01:25 PM
Deleting Rows where some Cells have same Content JamesT[_2_] Excel Programming 2 September 8th 04 08:41 PM


All times are GMT +1. The time now is 08:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"