I have some data that I pasted into excel and then used text to columns to return the data to columns of data. That's fine but one of the colums contains...

Hi I am wanting to create a drop down list, however, I want the list of values to reside on a different worksheet, but when I do this, I get an error to say...

How can I have the macro / vba prompt me for the name of the workbook and sheet each time I run it? Both the active sheet and the one I would be pulling from...

I am trying to match a Lookup Value with the largest of the potential Responses in a second database. =vlookup(B2,data range,4,False) I understood that...

i have a budget setup in a spreadsheet and i cant figured how to keep a balance updated on a loan without typing in the new balance everytime

Dear Mike. H, I am trying to explain in details. I have data for Excel woksheet for project as "Leave Application" 1) Start Date in "cell A1" (e.g. 12...

I should mention that I'd like the output from the table below to look something like this: 1000020 Td;Tz;Ug;Zm;Zw 1000035 ...

I have a list of 25 differnt numbers in cells from A1 to A25 How can I randomly pick 5 numbers from the range A1:A25 I would like the 5 number to show up in...

lets say I have the following info A1 A2 1 5 2 6 3 7 4 8 5 9 I want to tell excel to highlight any numbers in column A2 that...

I need to know if this is possible. I have a workbook with several worksheets. Each worksheet looks like (example): Worksheet #1 Column A Column B ...

Worksheet 1 Cash Inv. Amt. A B 1 13300 $200 2 13300 $.01 3 12333 $2000 4 12333 $.01 WorkSheet 2 Check Hist. Inv. Amt.

From an Access Query. I've got a list with the unique ID's for reports, and the next field indicates what Language they were written in. This was from a...

i am trying to create a financial record Book. and i want evaluate if the value of the number is negative and if so duplicate the value onto another cell.

I work for a college, and we have a program, called Informer, that automatically generates web queries from a database, called Datatel. What I would like to do...

Hi There I am trying to combine data from one s'sheet to another depending on conditions. I am trying to combine date from different spreadsheets into...

I have a wierd situation in opening a .xls file. I can open Excel then use File, Open to open a workbook and everything is fine. However, if I try to open a...

I have a column which contains the following type data 0125 - BYK-CRI-CC-SMITH All I care about is the 0125. Is there a formula that I could use that would...

Hi Guys, I think this is pretty basic but im not very good with lookups, ive had a look thru prev posts but cant find this (prob because its so basic).. I am...

I had troubles in earlier versions of Excel when I was needed more columns, than it was supplied in one sheet. Now that problem disappear for me because...

I've got a workbook set up with multiple tabs. Each tab represents a different slice of detailed information that's auto-filtered based on a status in a...