novice

  1. S

    Work Project - Formula help - Multiple sheets

    Hi guys :), Hope you are all well. I have ran into a major issue with my spreadsheet not pulling the correct data, which is meaning my whole spreadsheet is failing now. I am praying someone on here will be able to help me :). If you look at sheet 1 (attached) You can see that row 4 shows all...
  2. S

    Work Project - Formula help needed!

    Hi Guys :) I am a novice Excel user who is looking to automate my workload to save me time. I am currently working on a financial project for my business and I have attached a screenshot to show what I am talking about. I have my data which gets pulled automatically on the left and then I...
  3. S

    Excel help for a novice

    Hi Guys, In my current role I have to look at data for a financial year and change it into calendar year data. In my company, a financial year has 13 periods (4 weeks per period) and starts from April each year (e.g. 18P04 = 2018 Period 4). The issue I am experiencing is that with P01 being...
  4. A

    Using a Command Button to add new grouped rows with formatting, formulas, and keeping groups at the end of a growing table?

    Suuuuper fresh to VBA here. I've got a table that has many grouped rows all individually under their main banner row that I use for project management that has multiple rounds per project (hence grouped & banner rows). I am trying to add a "Add New Audit" button that adds a new chunk of rows...
  5. A

    Access 2013 Copy & Paste from one form to another

    Hello, I'm looking to copy particular information from one form and paste it into another form in access 2013. Does anyone know of an easy way to accomplish this? I'm a novice when it comes to access, I just use the basic functions. Thank you in advance.
  6. E

    VBA image lookup

    I have a table with over 1000 items, and growing, and i want to search for images that are part of the list. I've looked into the VLOOKUP method and while it works, I don't want to be limited by a data validated list. I would like to use user input for the search feature. I am a novice with VBA...
  7. F

    Basic/Novice Help w/Pasting Protected Data to Another Sheet

    I am trying to copy and paste rows from a 18MB .xlsb protected and heavily filtered -- from column N to column EZ. I want it to paste into a 998kb .xls file. I can't remove the formatting otherwise certain cells, (based off of dates generated from an external application) -- or It will...
  8. M

    Novice Needs Help: Broken Formula

    Hello All, Novice Here I am trying to use a formula that will assign a value based on the words it finds in the table. I am not sure what I am missing. I want the resulting value 1-5 to appear in the "Raw" column. The table below is the mock up of what I am looking to do. =IF([@Answer]=""...
  9. K

    Display amount of time (minutes) for a macro to run... (MS Access 2013)

    How would one insert an action into a Macro in Design View to calculate the amount of time (in minutes) that it took for a macro to run (in MS Access 2013)? Please and thank you.
  10. K

    Removing cell inputs and reverting to original cell format.

    Hi, complete amateur here. I am looking at making a button to remove the row of "L" on the attached image while reverting to the format of the rest of the table. I have tried a few very basic things and have exhausted all of my ability :laugh:. Thanks for your time...
  11. C

    Tough One? Yes for me, probably NO for you.

    First of all "Thank you" for reading this message and considering some help with my questions. Attached is a department schedule pdf. and I need a spreadsheet done so I could view it with the bar graphs and also a weekly spreadsheet to my weekly dates. My knowledge is best at "novice of excel"...
  12. J

    Help, Search Box Query

    Hi, This is probably a basic question but im hoping someone can save me time and explain the best/simplest way to create a search box? Ive been trying to use VBA, with limited knowledge/success, but i was hoping there's a simple standard function that can also work. Here's the breakdown...
  13. C

    leading 0 sometimes and number varies in lenght

    the number can be from 7-16 digits and sometimes leads with zero. I cant make it show with the lead zero because the number changes in length. please help novice user. multiple combinations like 9296030230000, 112924100, 050304566, 0956455156220000. I can use as text if needed. Thank you. Sorry...
  14. Small Paul

    vba to Open Workbook with Most Recent Date in File Name

    Hi All Firstly, many apologies, I know this has been asked and answered previously. Unfortunately I am not experienced (or intelligent) enough to make those solutions work for me! I am therefore asking about my specific situation. I save a daily .csv file in Sharesync with the previous...
  15. J

    Please help an old novice out.

    Please help an old novice out. The last time I was heavy into Excel was before the year had a "2" in the front (1990's). :eeek: I have a Excel questionnaire I've made that has 5 pages to it. The first page has two drop down cells for responses. if either of the two are yes, the other pages need...
  16. D

    Filter multiple sheets.

    I'm using this code to filter data based on a cell value: With Sheets("A1") .Range("A18:AM47").AutoFilter Field:=11, Criteria1:=.Range("K12").Value End With End Sub I would like to run this on multiple sheets A1 through A15. Any help would be appreciated. Thanks from a VBA novice.
  17. N

    Help with permutations

    I have 6 numbers and a letter (1, 2, 3, 4, 5, 6, X) that I need to list in every possible 4 digit combination that includes duplicates (i.e. 1111). Is this possible to do in Excel instead of having to manually type every one? I have seen a couple things online but it deals with Macro's, which...
  18. A

    BEGINNER USER: Assigning Values to Letters in Multiple Columns

    Hi, please note that I am a novice excel user, so very explicit directions are appreciated. I am hoping to track students' reading level progression through the duration of the school year with an excel spreadsheet so it can be easily visually represented with a line plot. Fountas and Pinnell...
  19. N

    formula code to give a score

    Hi All, I was wondering if you could help me. I have a value in cell B2 I would like cell C2 to give a score of either 1,2 or 3 depending on cell B2 So, If B2 score was >4.9, C2 = 3 If B2 was Between 4.8 - 4.4, C2 = 2 If B2 was <4.4, C2 = 1 I'm not very good at this so I was wondering if...
  20. S

    Wanting to simplify this formula - new to forums, happy to be told where/how i should be posting

    Hi i knocked up this formula to get the sum of a columnof cells only if the values in the cells next to them were less than 20. =(IF(J15<20,K15,0)+IF(J16<20,K16,0)+IF(J17<20,K17,0)+IF(J18<20,K18,0)+IF(J19<20,K19,0)+IF(J20<20,K20,0)+IF(J21<20,K21,0)) I'm sure there's a way of condensing it but...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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
Top