Hello. First time request for help, as I am learning.
My company has a pricing spreadsheet. Each customer has a separate tab. I need to find a way to populate one tab, with the information from the various company tabs, after choosing a company from a drop down menu.
Not even sure...
Good day - I have a code that needs tweaking for it to work as I intend it to, since I am very green when it comes to coding, I am asking for your assistance.
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("Database").Columns(2)) Is Nothing Then
If...
Hi there,
I'm tracking data for parliaments and would to like to take data from last year's excel sheet and populate new ones for 2021 that has slightly different rows, columns and ordering (so a copy/paste won't work). What the old and the new have in common is: country names and chamber...
Hello - I am having some trouble on how to automate excel to grab bits of data from cells in other sheets (same workbook) and bring it into a single page summary. For example, I am wanting to populate this table and based on what serial number is typed in (B-002 etc), the table below will...
Hi Experts
Please can you let me know how to accomplish auto numbering populated ?
I can use the formula
Concatenate with . =IF(A2<>A1,1,B1+1) but unfortunately the list is not ordered based on ID I am considering. Any help? There are 100s of rows and this needs to be auto populated with...
Greetings,
I'm making my way up slowly but surely to get better at VBA coding but the road is still long thus I humbly request for any assistance from your side :pray:
I actually have a worksheet as per below:
<tbody>
A
B
C
D
1
Date
Item X
Item Y
Item Z
2
3
4
5...
Hello all,
I am trying to create an At risk register so i can track my student that have several classes.
Each tutor has there register that they enter an (A)-Absent, (P)-present or (L(10))-Late and number Minutes, i need something that will look over the other two subject spreadsheets for a set...
Hello everyone,
I've searched the forums for a suitable answer to this problem but so far with no success.
I have a small worksheet with only 1701 rows of data.
I need to insert a new row every 5th row.
In that new row I need to populate 3 cells (D, E and F) with the same data each time, all...
Hello All,
I have been tasked with creating a macro that will allow for creating worksheets fasterfor the company's field technicians, and I have hit a road block.
My current project is to create a macro that will generate a series of worksheets (the number of which will equal the number of...
Hi there!
I am new to posting on the forum, but have been an avid reader as I work on my Excel skills (after switching from another platform).
Here's my question that is beyond my skillset:
I have a large list that I need to pull subsets from. My master list contains names, phone numbers...
Hi All,
I'm looking for help with creating a macro to pop-up an alert message if the value of cell "S8" on "Actual vs Plan" tab changes. Ideally i'd also like the message to display the change between the original value and the new value of cell "S8".
Something like this:
IF value of cell S8...
Hi,
I have searched and found code but none seem to work...
Let's assume the following from a dummy table: Sheet = 'Users'
<tbody>
A
B
C
1
Name
Empl ID
Manager
2
Mark
00001
Manager 1
3
Sue
00002
Manager 2
4
Joe
00003
Manager 3
5
Mary
00004
Manager 2
6
Jeffrey
00005
Manager 1
7...
Hello guys,
Looking some help in excel formula (not macros). I have group of units based on their sizes. e.g. type X=2 units, type Y=1 units, Z=3 units and so on filled in excel as below;
<tbody>
A
B
1
X
2
2
Y
1
3
Z
3
</tbody>
so based on the value in column B as above, I want all...
How do I create a macro that generates a new row with pre-populated formulas in each cell?
I actually only need to populate cloumns A through C in the new row(s). I'll need multiple macros as well, so the line where the row(s) are inserted will move if one or more rows had been inserted...
Hi all, I hope you can help me with what I would like to do. I've searched and searched and not come up with anything yet!! I have one sheet which is my 'data' sheet with a number of columns according to date. And I have another sheet which is the chart sheet. I want to populate the chart...
Hi Forum,
I've had a tough time searching for a solution with Google. I don't quite know how else to phrase it.
I have an Excel workbook where users input data. In two of the columns, D and E, users select from in-cell dropdowns (data validation). Each column has three selections to choose...
I have my userform set up with all the combo boxes. One of the Combo boxes(NamesDropDown) includes the names of all the students. As stated above each of the 6 combo boxes has the list of courses. I also have other text boxes in the same userform that will collect grades. What I need is that...
Hi all, please help,
Column C has rows of values. I want to populate column D as follows: IF Cell in column C is highlighted, then cell in column D = cell in column C, else leave the cell blank. Thank you.
If cell A1 says: #N/A N/A then populate from A2. However if A2 also says: #N/A N/A then populate from cell A3. If A3 is also saying: #N/A N/A then populate from A4.
I'm able to do this for just one switch, so I can get it to populate from A2 if A1 says it. But I'm not sure how to do it for all...
Let me start by saying I am an Excel novice.
I am trying to populate one cell of a spreadsheet comparing data from two separate cells. Let me explain...
I have a table of data that looks like this:
<tbody>
Phase
Date
Output
ENG
10/1/2014
A
ENG
10/2/2014
B
PRO
10/1/2014
C
PRO
10/2/2014...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.