All Questions
72
questions
0
votes
1
answer
83
views
Excel: Count Weighed Cells
I've an excel-spreadsheet, which is my timetable. this means, that I've some tasks, which is almost always a connected cell, sometimes I connect 20 cells, sometimes only two. Example
Since every cell ...
0
votes
0
answers
279
views
If Cell Contains Text Then Copy to Another Sheet
I want to copy a collumn on to another excel sheet where the first cell starts with: "Not Found"
If a cell in the first collumns contains "Not Found" I want to display them ...
0
votes
1
answer
686
views
VBA code for Multiple inputs search comparison
I need to search from a data in excel using a macro
If for example above image is a default list and if i gave a input using a input box.
Case:1
If input as "a1,a2,b1,c4"
it should reflect ...
2
votes
2
answers
87
views
matching all highlighted dates in one column to those of another column
I'm currently stuck on this step of my project. image of my document My ultimate objective is to highlight all highlighted dates in column P in column M. I was wondering if there was a formula so that ...
0
votes
2
answers
107
views
MS Excel - How to drop the character between the concatenated cells
I need to concatenated cells and put a comma between them. But some cells in the concatenated columns are empty and the result shows the commas between them. How to drop the commas if a cell is empty? ...
0
votes
1
answer
131
views
How can i simplify my code using LOOPS in VBA
I need to copy contents from a column in one worksheet and paste it into another (at the same time making a total of 7 copies of each of the variable). There are multiple columns and each column has ...
1
vote
1
answer
2k
views
Replacing a cell value with another value for multiple row
I'm having a problem replacing certain values in my sheet. I want to replace the value of the cell with another value in the same row if it is above the latter value and I want to do that for every ...
0
votes
1
answer
951
views
automatically updating the links of workbooks
iam looking for a way to open .xlsb files in a folder one by one and then rename or update its links as .xlsb.
For example if "C:\FINAL ANSWER\edit.xlsb" file has links as ='C:\FINAL ANSWER\MAIN ...
1
vote
1
answer
3k
views
Combine duplicate rows and get to a different cells to new column in Excel
I have a table of attendance which look like this,
Name | Date | Time |
abc | 12/3/2018 | 12:36:11 PM |
abc | 12/3/2018 | 08:30:11 PM |
EFG | 13/3/2018 | 09:35:11 PM |
EFG | ...
-1
votes
1
answer
1k
views
Excel VBA - Returning a list of values not found in one column
I want to get Excel VBA to return, in a messagebox prompt, all items which are in column A of worksheet Mastersheet but are not in column A of worksheet DeliverySheet.
Having a lot of trouble ...
0
votes
1
answer
182
views
Change loop to write results in additional cells
I have been using the following code for awhile but need some help in making one change. I’ve tried and tried but it won’t work. If someone could kindly take a look, my research says I’m looking for a ...
0
votes
2
answers
197
views
Excel offset from two different workbook, create a copy of one without affecting the other
I am using two different workbooks the first one [Excel Data only] created as a databse and the second one [Invoice Template] created to create an invoice.
When creating an invoice i am using offset ...
0
votes
1
answer
1k
views
Is there a way to link workbook data without getting REF errors when a row is deleted?
I currently have two workbooks, workbook 1 and workbook 2.
Workbook 1 - Sheet 1 is directly linking data to Workbook 2 - sheet 1.
I am linking by inputting the below formula into workbook 2.
='[...
0
votes
1
answer
5k
views
Copying cell from one sheet to another without formatting
probably a simple one to your geniuses however I need a fresh pair of eyes as I've been on this a while and can't see my error. I'm merely wanting to copy the contents of a cell from one cell to ...
0
votes
1
answer
250
views
Copying only certain cells from a row to another worksheet
I have a workbook that has a large number of sheets designed to help my team manage their workload more efficiently.
When someone requests a job to be done, a row is added to a sheet called 'pending ...