Insert row with button

Is it possible to have a main workbook with information from other  
workbooks at each worksheet? I have 20
workbooks with information. I would like to haven a main workbook with on  
sheet1 every row from the
20workbooks with category1, on sheet2 every row from the 20workbooks with  
category2, etc, etc. The information
in the 20workbooks in always only on sheet. The Colum in which the data is  
has no fix end. I go to fill in the
rows trough a user-form and comes always under the last row.

The mainsheet has to update every time it opens (and if possible a button  
on the sheet to update manually)
without opening all the other documents.

I would like to make the connexion with one subsheey an the mainsheet and  
then copy the subsheet 20x with the connexion



SUBSHEET1 		SUBSHEET2 		SUBSHEET3
Categorie3		Categorie1		Categorie2
Categorie1		Categorie3		Categorie3
Categorie3		Categorie2		Categorie2
Categorie3 		Categorie1
Categorie2 		Categorie3
Categorie1 		Categorie2
Categorie1


MAINSHEET
Sheet1		Sheet2		Sheet3
Categorie1		Categorie2 		Categorie3
Categorie1		Categorie2		Categorie3
Categorie1 		Categorie2		Categorie3
Categorie1		Categorie2		Categorie3
Categorie1		Categorie2		Categorie3
Categorie1		Categorie2		Categorie3
			Categorie2		Categorie3
						Categorie3


-- 
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
0
12/11/2006 10:48:30 PM
excel 39879 articles. 2 followers. Follow

0 Replies
446 Views

Similar Articles

[PageSpeed] 56

Reply:

Similar Artilces:

how to Assign Hyperlink to Button in Spreadsheet
I create a button with command tool ber but cannot find help to assign a hyperlink to it Can you use a button from the Forms toolbar instead? Then you can just right click on that button and assign hyperlink. Warren Deeker wrote: > > I create a button with command tool ber but cannot find help to assign a > hyperlink to it -- Dave Peterson ...

There is no send button for sending files and webpages
There is no send button to send webpages, files, etc. How can I install one so that I can send these? Where would you expect this button to be? Normally the send command (not button) for web pages is on a menu in your browser and for files it's on a right-click context menu. "surfknight" <surfknight@discussions.microsoft.com> wrote in message news:16F5DA54-A010-4E3B-B3E1-6C4787FBB036@microsoft.com... > There is no send button to send webpages, files, etc. How can I install > one > so that I can send these? Hi vince, when I try to use the Send command; ...

Copy certain rows to new worksheet
Hi everyone I have 5 worksheets in my workbook. In each sheet, column A is left empty for the user to select a number from 1 through 6. This is actually for ranking the rows (1 being best, 2 second best and so on) Ranks 1 to 6 might be all on one sheet or they may all be on different sheets. I would like to have a summary that will copy these rows (1 through 6) onto a separate worksheet, done by macro or vba. Perhaps by looping through each worksheet and doing a copy?? Any help would be appreciated. Thanks, Dave On Sep 15, 6:03=A0am, Dave <Dave.Bea...@lhsc.on.ca> wrote: > Hi ev...

Returning last number(time) in a row of cells
Need some help with this one please; Row A4 thru J4 A4 B4 C4 D4 E4 F4 G4 H4 I4 J4 12:00 15:00 16:00 I need to return to cell K4 the last number in the above row. I do not know what formula to use. Any help would be greatly appreciated. There are several ways to achieve that, - here are two: http://img9.imageshack.us/img9/9398/nonamegi.png Micky "v1rt8" wrote: > Need some help with this one please; > Row A4 thru J4 > A4 B4 C4 D4 E4 F4 G4 H4 I4 J4 > 12:00 15:00 16:00 > ...

Delete Rows #2
I would like to be able to delete a row with a name in it based on a cell with that name from another cell in a different worksheet. Any ideas? Thanks, Bernie Hi Bernie This example loop through row 1 - 100 on the activesheet and if the value in A is the same as in Sheets("Yoursheet").Range("A1").Value in delete the row Maybe you can use a Autofilter if you have many rows (faster) See this page for more info http://www.rondebruin.nl/delete.htm Sub Example2() Dim Lrow As Long Dim CalcMode As Long Dim ViewMode As Long Dim StartRow As Long Dim End...

Deleting all even numbered rows?? Help
I have some data up to row 2200. Unfortunately, the data was capture with a glitch, to where all even numbered rows (2, 4, 6,.....2200 contain bogus data. I want to delete all even numbered rows in the spreadsheet, and hav the 1100 odd numbered rows shift up, so I have only 1100 rows of th real data on the spreadsheet -- Yel26 ----------------------------------------------------------------------- Yel268's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1570 View this thread: http://www.excelforum.com/showthread.php?threadid=27234 Hi one way: - in a helper c...

GridView
Hello, I have a GridView with a number of rows in it. I need to scroll up and down the grid view in order to see all the rows. The problem is, when I scroll down, and highlight a row, then click "submit", when the new page is rendered, the GridView shows the first row, not the row that I show highlighted (after scrolling down and clicking on submit). How can I fix this problem in both IE and Firefox? Thanks Jason On Dec 12, 12:54=A0pm, Jason <jason.wu...@gmail.com> wrote: > Hello, > > I have a GridView with a number of rows in it. =A0I need to sc...

Add a button to a sheet to open a userform
I'm looking for a way to add a button to a spreadsheet that will open up a userform. I've seen it done before, I'm just not sure how do it. Thanks, Chris -- PokerZan ------------------------------------------------------------------------ PokerZan's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=23480 View this thread: http://www.excelforum.com/showthread.php?threadid=380247 Hello Chris Add a Command button to Excel double click it so it takes you to the vb code & enter UserForm1.Show (between Private Sub CommandButton1_Click() & End Su...

Inserted Picture Gets Forced to 32x32
I inserted a picture into my email body (HTML format) without specifying the size (I want the reader to see it in its natural size). Sometimes (usually when it is a forward of an existing mail) the recipient receives it in 32x32. Why does this happen? The copy in my Sent folder looks normal. Sample of what recipient receives is below: <div> <p class=MsoNormal style='margin-left:.5in'><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'><img width=32 height=32 id="_x0000_i1025" src="file:///D:\My%20Documents...

Error inserting clip art, etc.
Every time I try to insert clip art, etc. (with '97 version) I get the error message: "Publisher cannot launch or communicate with the OLE server program needed to complete this task. There may not be enough disk space, or there may be a problem with the server program. To make more disk space available, delete some unneeded files on your hard disk. If you suspect a problem with the server program, try reinstalling it. Then try this task again." I have removed and reinstalled publisher and still get the same error message. Any other ideas? There are a few things you can...

current row in formula
How do I use a reffer to a current row in formula Example: A1*B1/C1 A&Row()*B&Row()/C&Row The example above doesent work but want column to be fixed and row depending on the row it's actully is current. I want to formula to be working when I copy it from one sheet to the other. Cheers, w =INDIRECT("A"&ROW())*INDIRECT("B"&ROW())/INDIRECT("C"&ROW()) -- David Biddulph "willemeulen" <willemeulen@discussions.microsoft.com> wrote in message news:FD15A0F8-263D-4306-B042-C61704D32B73@microsoft.co...

Removing Duplicate Rows
HI, I HAVE A FILE WITH 11,000 ROWS, MANY OF WHICH ARE DUPLICATES. FILE ONLY HAS 2 COLUMNS. IS THERE AN EASY WAY TO REMOVE ALL DUPLICATE ROWS? THANKS IN ADVANCE FOR YOUR KIND HELP. MATT -- bvinternet ------------------------------------------------------------------------ bvinternet's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25525 View this thread: http://www.excelforum.com/showthread.php?threadid=389619 Yes, explore the Advanced filter (menu Data>Filter>Advanced Filter) Regards, KL "bvinternet" <bvinternet.1sn26a_1122149106.90...

Blank row #2
I'm entering numbers under a colum, I need the total sum of the colum; But after I enter the last number 221 and press enter it always needs to skip with a blank row or cell ? it does not mater how many rows I enter, I need a blank cell before the total. Thank you very much. JA ex: 123 222 111 221 ---> Here is where I need the blank row allways 677 This is the total sum File Attached: http://www.excelforum.com/attachment.php?postid=334735 (book1.xls) ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages dir...

Deleting/removing unused rows in a worksheet
Excel 2007 all MS updates Is it possible to delete rows without ANY data automatically? Currently, I have a 2000+ row spreadsheet that has 250+ blank rows. Instead of doing this manually, how can the removal or deletion (squishing!) of the blank rows be done? For example, say I have a spreadsheet with data in rows 1, 2,4,6,8 and 12. All I really need are THESE rows with data. I want to squish, eliminate, delete the rows in 3,5,7,9,10,11. How can I do this by 'highlighting' or whatever the entire set (rows 1-12 above) and then performing an "delete empty row"...

Insert Function Wizard agrument descriptions.
I have written several functions in VBA, then saved the sheet as an .xla which I use as an add-in. The functions appear in the Insert Function Wizard, as expected - almost. I have not found a way to display the arguments' descriptive text. I know this is available in in .XLL's through a call to xlfRegister, but how does one accomplish this through VBA? Dan You can add a brief description of your UDF by going to Tools>Macro>Macros. Type in the name of your UDF and "Options". Add a description and hit OK then Cancel. To actually add the arguments you will need...

Can a string text be inserted within an Error Alert text box?
Is there a way to create a string text within Data Validation, Error Alert text box? If so, I want to use a combination of a sentence with the returned value of a cell. The Error Alert box might read something like: You have 5 days remaining. 5 would be the cell value that would be inserted within the text. Thanks in advance. Michael Hi, Nothing built into Excel to handle this, you might be able to do it with VBA This site has a lot of stuff on Data Validation, check it out, it might have something on what you want. http://www.contextures.com/index.html If this helps, please click t...

DoubleClick on a SingleClick button
Hi, I have a JS with a button and OnClick event which runs an EXE that calls a COM Dll to present a Modal Dialog. If the button is clicked once everything is great. If the button is clicked twice I get the Dialog, but the focus is lost, it is on the JS webpage. I understand that this is an expected behavior, but I still need to find a workaround. One way is make the DoubleClick Event and the SingleClick Event of that button do the same. For now I dont know how to prevent the DooubleClick Event being caught by 2 SingleClick Events of that button... Another way I could go with, is some wor...

get code from some rows
Hi I have this data: A B C D 1 code1 name1 2 3 4 5 6 7 8 9 10 code2 name2 I have each ten rows a code in column A and other data in the other columns. I want the codes that repeat each ten rows to show in column D like this: A B C D 1 code1 name1 code1 2 code2 3 4 5 6 7 8 9 10 code2 name2 Thank you so much Strictly speaking, your codes are appearing every 9th row, going by your example. Is your next code on row 19? If so, then you can put t...

Decimal place formatting button doesn't work when some cells already have no decimals
Say I have 2 cells w/ values: 35 35.87 If I use the formatting bar button to drop the decimal places, nothing happens, and I get an error tone. My recollection is usually Excel "does the right thing" and will drop the decimals on those cells for what it can (and this is what I want to happen). So in what arcane place to I configure this to work the way I want it to? Thx Dear TrippKnightly I understand you want to show the cells entered as 35 and 35.87 as 35 and 36 respectively? To do this, highlight the cells you wish to format with no decimal points. And go Format/Cells...

Select rows, then sort
Hi All, Word2K, single table. My needs are simple, and I've been searching groups for days to find something I can use. We all know that Word moves empty rows to the top if the whole table is sorted. I don't want to populate them with Z's or delete them to prevent this, so here's what I want a macro to do: 1. start selecting rows in Row 2 (Headers in Row 1) 2. stop when first row with empty cell in Col 2 is reached 3. sort alphabetically ascending on Col 2 (text entries) 4. with range still selected, update fields (SEQ nums in Col 1) Right now, users select populated ro...

Need help setting up a complex row source
I'm trying to create a form to let the user create new entries in a link table. The problem is that one of the two FKs in it refers to a table that doesn't have any one field that is suitable to use as an identifier in the the forms combobox. Two values which are in the table via foreign keys do provide a suitable userfriendly identifier for the rows of the table. I can't do this directly when creating the form since at most I can pull the two FKs, not the text they're associated with. This also appears to be beyond what the form wizard can be coaxed into doing, and I don&#...

Insert "/" in the middle of the string
The purpose of this is to make sure the users have enter the correct data in the correct format. The correct format is like this: P/2003 So, whenever the users enter a "P" automatically a "/" is inserted to the text. Or if the users just enter P2003 only, then P2003 is changed to P/2003 automatically. Is this possible to do in Excel? Please advice. Thanks. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ Yes it is possible how it is done will...

Inserting a full file path and name into a field
Hello, I have seen Arvin's Document Management database from here http://www.datastrat.com/DataStrat2.html but the browse doesnt include the file names, only the directories. The following API can search for files: http://www.mvps.org/access/api/api0001.htm but won't allow me to insert the full path into a field (including file). Unless I have missed something. How can I do it? cheers! ...

Track in CRM Button Disappearing
On many of our user's systems the Track in CRM button continuously disappears. If they log out of Outlook and back in the button reappears. This is very inconsistent. The users were upgraded to 2007 from 2003, but this issue also happened on 2003. Any ideas would be greatly appreciated. Thanks! Please have the users check to make sure that Outlook is not seeing the CRM plug-in as a security threat. The link should be under the Help Menu within Outlook. Please make sure that the users have the CRM site listed (within the browser) as a trusted site or as an Intranet site. Thank...

inserting images
I have a spreadsheet of contact/address data. I want to include an image for each row of entered data. How can I do this and have the image display? I've tried inserting a object, but it only places a box or icon on each row. I have inserted a hyperlink for each row, and that's okay, but I want the picture to be visable without having to double click a icon. Any hints? Thanks in advance. TC What happens when you click <Insert> <Picture> ? You should get another window with a choice of browsing to files and/or folders to choose various types of images from your m...