texas

  1. M

    Need Help Archiving Live Updates

    Hello members, As a lot of new members such as myself, I am quite green in my macros abilities. To cut to the chase... I have linked some live updates from the web in my excel spreadsheet. However, I would like to archive the data every 15 minutes and list it in each subsequent column. The...
  2. G

    copy/paster to another worksheet

    I am trying to find a code that will copy and paste cells to another worksheet based on other cells value. The cells with value 1_1, 1_2. 1_3, 1_4, 1_5, 1_6, 1_7 1_8, 1_9, 1_9, 1_10, 1_11. 1_12 are the values in column f. These rows would be copy/pasted to another worksheet. Any help...
  3. G

    Add number to cell based on another cell's value

    I am trying to find a way to insert a number in Column B (Person_ID) based on Cell Column G that is Blank. Then repeat the number in Column B until reach the next blank cell in Column G. Add 1 to number and repeat, thus giving each soldier an ID number. This would Loop to the end of worksheet...
  4. J

    Auto-Populate Cells Based on Input

    Hello Everyone! I'm a landscape architect and part of my job is working on Tree Preservation Plans. Basically what I'd like to do is input the Species, DBH, & ACTION (In Yellow) and have it populate the cell (In Green) based on the category in F3:N3 (Significant Trees, Heritage Trees, Etc..)...
  5. H

    Need to create new sheets and move data to each sheet

    Hello, I was hoping that someone could point me in the right direction. I am decent with macros, but creating them from scratch is where I struggle. I enjoy learning how to adapt code that I find on this forum and making then work for my needs. This time, I have a situation where I have two...
  6. E

    Need Help With AverageIF with specific text

    I am trying to find the average of specific states (four to be exact, Alaska, Nevada, Florida and Texas) in my list of excel but I keep getting errors. I've tried: =AVERAGEIF(A1:A10,"*Texas*","*Nevada*","*Florida*","*Alaska*",B1:B10) but its tell me I have too many arguments. Can anyone help me...
  7. J

    Lock Cells

    I'm trying to sort data in a range of data, but i'm need to lock some of the cells within to ensure that the formulas in the cells aren't changed. Here is an example of the data that I need to sort. Is there a formula or VBA code to lock these cells, but still allow them to be sorted based on...

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