Thank you in advance for your help!
So I would like to have a separate sheet for certain data that is entered in another sheet, but all located in the same book. Is there a way to do this?
For instance, if the text in cell D2 matches a certain criteria, then excel will auto-populate...
I can't get excel to do what I want after creating this VBA script:
LastColumn = ActiveSheet.UsedRange.Columns(ActiveSheet.UsedRange.Columns.Count).Columns
For n = 63 To 63
For i = n To n
Would anyone happen to know why every time I go to one specific sheet in the Google Sheets/Excel workbook I'm working on, that particular sheet has all of its cells highlighted?
I'm guessing it's something simple I'm missing.
Every time I go to that one sheet, even if I click a cell to remove...
I am trying to use formulae to check that the order number (sheet A, cell B4) and week due (sheet A, cell Q4 as YYWW) values are found in the same row of sheet B. The order numbers are stored in column E of sheet B, the due date is stored in column O of sheet B as WW.
Note the order number...
I tried to open an old Excel sheet, and columns A through AM were hidden. I cannot open the hidden columns by using the Unhide action (highlighting the entire sheet). Any suggestions that would enable me to open these hidden columns would be appreciated. Thanks.
I got one vba solution on this site given by DanteAmor,
if any header missing then I want to add message box for user and exit sub
Dim sh1 As Worksheet, sh2 As Worksheet, a() As Variant, b() As Variant
Dim i As Long, j...
I have a workbook that has two sheets. Sheet1 and Sheet2.
Sheet 1 will have employee names in column "C"
The name will appear on sheet 2 in column "C" as well
The times I want to lookup are in columns G and H in sheet2
I am using this formula below in column M and N in Sheet1 to find...
I am working on a project and it has been a while since I've had to use any VBA, so I'm saving the time and asking. I have data on two separate worksheets. I want to compare column B on Sheet 1 with column N on Sheet 2. Any values that do not match between the two columns I would like to...
I have an idea for a search sheet that i have no idea how to create, and am looking for help.
I would like Sheet 1 to just be a search box and you can type in an address, and below it will be a table that will show the results that match your search. The matched search data will be stored on...
I hope someone can help me?
I have a workbook sheet 2 contains lots of data.... I would like to be able to find anything on sheet 2 that contains a specific word ( ie Adobe)
This would than display the data on sheet 1. A bit like vlookup, but vlookup as you are aware only picks...
I have a worksheet with a mixture of data entry cells and cells derived from formulas.
I want to protect the formula derived cells so I have locked them and protected the worksheet (no password).
I have various buttons running macros to perform bespoke filters. These are inoperative because...
I have a very difficult and specific request that I would like a lot of help with please.
I have a very large macro-enabled workbook with around 260 sheets. Originally, I used some VBA code so that no matter what sheet the user was on when they saved and closed the document, the next time it was...
I'm looking for a macro to jump to a cell in sheet 2 based on the content of a cell in sheet 1.
Basically what the macro should do is:
Find cell A1 of sheet 1 in column B of sheet 2 and go to that cell.
I've looked for a solution but couldn't find it. Hope it is a simple question...
I'm getting totally crazy over the RANK-function.
In this sheet, B2 = RANK(A2,$A$2:$A$3) and B3 = RANK(A3,$A$2:$A$3),
and as you can see, it gives me two different ranks for the same value.
These are constants (not formulas) and prove that the value is the same, formula in C2 =...
Sorry for the terrible header but i'm not sure how to explain this correctly.
On one sheet I have 1 column of numbers. Each number is on a row with further data. Some columns have no data.
Some numbers are duplicated in the first column.
On a second sheet i have the same list of numbers...
I have 2 columns on Sheet 2
In column A it says Mon all the way down to A10
Then Tues for a few more cells below, then Weds for a few cells and so on.
The list is sorted in order
To the right in Column B some cells have numbers in them and some are blank
On Sheet 1 I want a summary, so it...
I have a simple workbook with two sheets.
Sheet 1 contains:
Sheet 2 contains a message: Choose a person
I then has a dropdown/combo box (data validation list, the source being the list...
Hello, I am trying to export a specific range of cells (A1:E18 for one and I1:M18 for another) on a specific sheet and save it in a HTML table, separately. The code I have below is what I found and have been working with to try to modify but as I make changes I don't seem to be affecting...
Sheet 1 and 2 are a Timesheet setup in a table. Table1 Sheet1 and Table2 Sheet2. Sheet 1 is the 1st 2 weeks of the pay period, Sheet 2 is the second 2 weeks. Formulas in the Table autofill in case a new row needs to be added based on spit days.
What I need to do is copy data from 1 of...
Good afternoon all,
I am having a problem as I modified my excel workbook and I am unable to find the sum I'm looking for. I keep getting #Value !
I have dates in cells P1 and P2, start date and end date. This is located on a sheet called Records. I have a datasheet that is full of data from 3...