populate cells

  1. X

    Populate info from one tab using cell as a reference

    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...
  2. Sumeluar

    Code to check for two conditions on a named range

    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...
  3. A

    Transfer data to multiple columns from one workbook to another using info from two columns

    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...
  4. J

    Populate data from different sheets into 1 page based on criteria

    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...
  5. N

    Auto populate numbering sequence

    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...
  6. S

    Populating worksheet with a range of dates from a UserForm

    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...
  7. A

    Trying to create an at risk register to track my students

    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...
  8. M

    Insert same text every nth row

    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...
  9. L

    Populate multiple templates with existing table

    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...
  10. D

    Populate cell with info from one column based on criteria from two other columns

    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...
  11. M

    MACRO to pop-up alert if value of cell changes

    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...
  12. N

    Auto Populate Column

    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...
  13. C

    Auto fill in rows based on cell values

    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...
  14. O

    Macro for Inserting Pre-Populated Rows

    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...
  15. J

    Compute and populate the chart from date range

    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...
  16. N

    Automatically Change String Value of a Cell Based on the String Value of Another Cell

    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...
  17. D

    How do you transfer data from combo box on userform to worksheet?!

    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...
  18. B

    IF Cell in column C is highlighted, then cell in column D = cell in column C

    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.
  19. K

    How to populate from one cell if another is empty, multiple times?

    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...
  20. S

    Populating a cell based on data from 2 different cells

    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've detected that you are using an adblocker.

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.
Go back
Back
Top