novice

  1. 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.
  2. 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...
  3. 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...
  4. 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]=""...
  5. 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.
  6. 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...
  7. 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"...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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.
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. C

    Scrubbing certain criteria and Highlighting the results

    Hello Community, I have spreadsheets sent to me that need to be scrubbed for consistency before they are sent off. My knowledge of VBA code is rudimentary at best. These sheets can contain 2500+ lines of content, the amount is always different but the content needing to be outed is always...
  18. M

    VBA printing challenges

    I am new to VBA. I have been researching on the internet and can't find answers to my questions. I look for ward to assistance. I need to print two worksheets and two ranges (fixed - not dynamic) from two OTHER worksheets. I have gotten parts of it to work but I am not able to combine...
  19. A

    How to add automatic text in a column after entering a number

    Hey guys, I'm completely new to this site and quite frankly it is my first time joining a forum. I'm trying to set up an excel sheet where I can record the weights of an object. In the column I want to be able to enter the weight as a number, lets say 40, and have it return as 40 lbs. Is this...
  20. B

    Help with a search function or formula...

    This is my first time ever to post in forum. Please forgive me if I do something wrong. Okay, here is my question. I currently have a spreadsheet that contains roughly 10K rows and 25 columns. There are two columns in this spreadsheet I want to make use of and they are item number and bin...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top