stuck

Hi All, The worksheets I have, require deleting all columns shaded green on row 13. Up to and including column 150. I have a spreadsheet with headers on row 13, and a few thousand rows of data thereafter. Variable number of columns, starting from 100 to several hundred depending. My problem...

I have a situation in which I need to calculate Z (teams) *AA if BOTH X and Y = 1, and the same for the alternate values of Z (2 and 3) while keeping them separate because I need to later in the spreadsheet show the value for each record by team. X Y Z AA 1 1 3547 1 2 0 9987 5 3 1 1597 4 2 0...

Hi guys, this is my first post. So I've been trying to set up an order form that has drop down menus and vlookup data with a separate sheet for the lookup tables. I want to set up a bunch of macros for each different option so that when a specific option is selected in each of the drop down...

Hi everybody. New to this forum. :) I just have a really quick question about Class Modules. The only problem is I am clueless with Excel and have a deadline for tomorrow to do this exercise for. I have about 5000 rows of data like this: <colgroup><col width="64" span="3"...

Hi, wondering if someone could help - or at least tell me if something is possible. I am trying to Return the total number of B's from a range of data, I.e. if the cell above is a B I want it to count the number within the range. Something like this: <TBODY> Data</SPAN>...

Hi guys, I've been working on the for 3 days now and cannot find a solution. what i need to achieve is the following I need a formula to count (Paid Weeks) how many cells for each row have a value higher than 0, between the Week Ranges (Week 1_13 etc) in the top row, based on the "Start week"...

I have found a solution that may help others who, like me, could not get the well-documented fixes to work .... Scenario: Worksheet shows as 'Calculate' in Status Bar, despite Excel Options being set to Automatic, Pressing F9 or Calculate does a recalc but 'Calculate' reappears immediately No...

I have recently inherited a spreadsheet at work with various macros included. One of the macros is currently pulling through an error despite it been the same as in a similar file. I am currently unable to find the reason for the error. Can anyone help? Thanks Sub InsertRow()...

I have an Excel spreadsheet with numerous hidden rows. I find that under normal circumstances with non-merged cells, when I press enter Excel will move down to the cell in the next visible row. It works great. However, I recently discovered that under some circumstances this is not the...

I am trying to sort my spreadsheet so that Column C matches up with Column D. Both columns have 9 digit id numbers in different order. Ascending and Descending does not help because Column C has 1121 items and Column D has 1155 items. I would like to sort so that Column C matches up with the...