I want to set up a new workbook using bits of data from existing workbooks. Say data from workbook 'A' cell c21 to new workbook 'C' cell h42, then from...

Hi I need help I want to look for a cell in column if we find the cell in the column “ the value of the cell” write 1 if not write 0 For example – I have A1...

Okay, This may sound like a dumb question but how do I restore the command bars in Excel. I've managed to delete them all while playing about with the...

I need to find the Draw toolbar so I can add lines to a file. No Draw toolbar up on top???

I've learned to add an accumulator to multiple cells using the code on http://www.mcgimpsey.com/excel/accumulator.html Private Sub Worksheet_Change(ByVal...

Hi All In Excel I have a customer list of Name/Address/ Contact info etc - which individually appear in text boxes in User Form1 when scrolling down ...

:confused: I want to format a cell to display the current date (dd/mm/yy) upon opening the spreadsheet and automatically update the same way Microsoft Word's...

I have a survey whose answers were recorded in Excel. The answers for a particular question extend from Q6 to Z505. I need to count the people who did not...

I am using MS Excel 2000 and I want to password protect a worksheet to protect the format and formulae but still allow users to use the filter facility. Is...

Hi, I generate 100-200s .csv files end of each month for my company. Each of these .csv files have numerous data that I need to sum up for...

I have several Workbooks in a folder. Each Workbook has only one Worksheet. How can I copy all the Workbooks into one Workbook with as many worksheets as...

Hi Using Excel - In column A I can enter 4 different cash values e.g. 30 / 13 / 10 / 5 using the formula in column B/C/D/E =IF(A3=Rate_30,A3,"") 30 shows in...

I have a monthly budget which I have been using for a few years. And for those years I’ve tried to write a formula so that a row does not show the last...

Pls tell me what macros are, and what benefit(s) do they serve? I use office 2003

Hi All On A User Form I have a Frame with 6 Text Boxes within the Frame - is it possible to just print the Frame and the Text Boxes within the Frame -...

I'm creating a price list and need to have an average price list out of 6 prices on the end end of each line for about 1500 lines. Individually doing this...

Hi, I have several spreadsheets that I need to increment a column each time information in another column changes. Using example below, each time program...

Hello, I am trying to determine if it is possible to convert a 6 digit number into a week - for example: 050525 = yymmdd = 2005, May 25th and I want my field...

Hi, I have a bar chart that shows projected and actual numbers for four quarters. I'd like to label each pair of bars with the PERCENTAGE between the...