I have a spreadsheet with 14 columns and 20 rows - and what I would like is a formula that will look in a particlular row i.e B1:B14 and return and X in cell...

i am new to using excell and my accountant has created a spead sheet for me , i was wondering can i set up a page so that the information i enter is done on...

I created a work book which I wanted tp print out A4 size. When I go into print preview my work is tiny about 2 inches square. When I print it come out the...

Greetings: How do I view the code for a built-in macro? Specifically, I want to see the code for "next sheet" and "previous sheet" (Crtl-PageUp &...

I have a table of approx 120 cells which contain what is supposed to be a number of hours:mins:secs but in the formula bar a date and time is shown. Example -...

i have created a custom lists and now i want to use it in a worksheet. how do i get the cutom list onto the worksheet

Hello, I want to open an excelworkbook from a template, this works fine by just opening the template. But when opening an excelworkbook generated by the...

I have 12 monthly worksheets of catalogue item information on rows. I want to build a summary worksheet that summarizes one of the columns (qty sold) by month....

I have two sets of data (2 worksheets) one set contains a column with 14000 different numbers and a second column with corresponding values to these...

I have nine workbooks I have combined into one workbook using the drag-and-drop system as described by Bernard Liengme on 11/25/07. All the workbooks were...

I have written a macro that takes me from the worksheet where I am entering information regarding an event to a worksheet that has a drawings of various table...

Hi, This formula has references to other sheets in the same file. I have this formula in A1 : =IF('47'!$B$10;'47'!$B$1;" ") I have this formula in A2 :...

I'm having troubles finding a formula for this guys. I have a bunch of data which I need to have filtered out and placed somewhere else. If you look at the...

Hey guys, I need some major help here. I want to make a table off hours that our friends can be online for assistance but the problem is that I need to make...

I want to create two excel sheets. One to print OT the other to print NT. How do I program a variable to give me a 5 by 5 print out of 27 or 39 names (books of...

Hi i have two different excel files with two different names. if i make entry in one excel file , the other file should be update automatically. (it...

Friends, Can any one suggest me about how to add macro toolbar button in microsoft excel 2007.I have a macro code which is running correctly to my...

I am attempting to count the number of times a specific value range occurs in a row throughout a large spreadsheet. For example, I have three values in...

Check it out: www.BrandonsMansion.com

Hello Xcel spreadsheets Copied from User's Network Home Folder to Another Network Folder. copy \\network\home\userA\*x.s \\network\REPGROUP Getting "object...