I am needing help - after days of searching the discussions and trying a few suggestions, I cannot seem to find an answer to my issue. I have timecards of 10...

I have data , that can not be stored in only one worksheet , so I must divide this data into smaller parts, but is it somehow possible to define a dynamic...

Hi there, I have a huge spreadsheet that is downloaded out of another program every week listing all staff and their rosters for the week. The dates and...

Hi, I am dumping data from an external system into Excel via a 3rd party application. When a particular field comes into JDE, its come in as text. i.e....

I am looking for a formula that would gather a range of data from mulitple tabs and put the value of one column in a "summary" tab. Example: I have 5 tabs for...

I have recently entered the world of Data Cubes and Pivot Tables, so this makes me a rookie. I am somewhat of an IT Journeyman in that my skills, over the...

Hi, I have data in a particular form. One of the rows in this is using formula. I need to depict this data in a different form and still retain...

Hi, I am working with an existing form in Excel. There are 4 tabs with different forms in each tab. When I close the workbook, the data in two of the 4...

How do I format cells to get rid of a green triangle in the cell?

Is there a way to anonymize say a column of employee numbers in Excel? I want it done in such a way that for each year of data the number is encrypted the...

I am using Excel 2007 and here is an simplified example of what I need. Items Price Potatoes 4.35 Apples 5.55 Oranges ...

enter 1 in a cell and it enters static date in next...Have this working in one column with the following but need to have it work in columns Y:Y and AA:AA...

I am tracking daily information with a formula for weekly results. I then want these results to enter into another worksheet to track monthly results. My...

When I exit a cell after entering data, the worksheet "save"hourglass displays for 30 seconds or so. Can I delay that step until all data has been entered?

I am trying to set up a form that I can enter all my information into one single sheet that pops up when I enter the excel file and then once I hit OK then it...

Some of the data I enter is 12-15 key strokes long. Many of these entries are the same. Are there any shortcuts available, that allow me to reduce the typing...

if i type the number 3 in cell b1, how can I get that value copied into cell c3? and then when i type in cell b2, to have that value copied into cell c3 which...

I am trying to use a data entry form to write a new data line into the next blank line starting at cell A12 and ending at ending at cell AG12. There are a...

hi i have a spreadsheet that has columns to indicate the outcome of certain accounts at work. for example: Not proceeding Gone Elsewhere Changed Mind

I am using two worksheets in the same workbook for date, address, file #, etc. One has 10 columns, the other has three with the same data. I am trying to avoid...