novice

Hi All, first time posting currently as part of my job I create an excel with many tabs... sometimes as many as 150. I have several questions. Firstly, the tab structure is such that the first 8-10 (this can vary) tabs have specific names from there the sub sequence tabs then follow a...

Hello I want to start out with saying am not familiar with VBA programming and have been struggling with this task. I have been trying to do some research and figure out what I need to do to accomplish my task. What I am trying to do is go into a folder and pull specific data out of some excel...

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

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

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

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

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.

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

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

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]=""...

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.

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

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

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

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

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

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

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.

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

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