All Questions
9
questions
1
vote
1
answer
646
views
Copying cell colors to another sheet
My active sheet (let's call it Sheet1) will be main for all users to edit and view.
User 1 only needs to view half the data in Sheet1 at a time so I've created a Sheet2 to only display the data that ...
1
vote
1
answer
73
views
Compare excel worksheets
Here is the problem I have been trying to resolve all morning - I have two Excel worksheet files:
Subset: This file has a subset of employees with various details including training status such as in-...
0
votes
1
answer
258
views
Weird VLOOKUP issue in a macro heavy worksheet
I have quite a weird issue with a workbook I built that is very macro dependent. It centers around a simple VLOOKUP().
Currently my macro creates a line item on one sheet (Sheet A), then copies said ...
0
votes
1
answer
297
views
Using VLOOKUP across worksheets without referencing the original worksheet
I've got a workbook that runs a few macros to pull in copies of sheets from a number of other workbook. I'm trying to set up one file that users can copy to their project folders and then just use ...
0
votes
0
answers
786
views
VBA vlookup error
There are about 1200 rows with data after the first part of the script has run. Afterwards I want to run a vlookup for column 6, which has the initials of the person handling the problem, against a ...
0
votes
1
answer
6k
views
How to populate information from one sheet to another in Excel Workbook?
My current task is to create a formula where my information from one sheet will auto populate in another sheet when the product description is copied.
To be specific, we need to have the items ...
0
votes
1
answer
700
views
Need to transfer a column's data. I have 2 sheets with same data and need to move corresponding data from one to another
I have 2 excel sheets and both have one column that has matching data. However Sheet2 has a column of data that Sheet1 does not have and I need to input the corresponding data from Sheet2 into Sheet1 ...
0
votes
2
answers
4k
views
How to lookup a value and return multiple unique values to a single cell - comma separated
I am attempting to lookup a unique identifier (Product Number) which is held in several different stock locations. For example:
__A__ __B__ __C__
1 Item # Warehouse ...
12
votes
3
answers
399k
views
Searching for a value in Excel, returning yes or no
I have one workbook, with two separate worksheets. I want to know if the values that appear in worksheet B also appear in worksheet A, if so, I want to return a "YES". If not, I want to return a "NO". ...