noob

Hello everyone, I'm a mega noob a Macros and i want to learn, i had a question how to paste stuff in the next availbale free space not over writting so i googled found your forum which i now love and added to favorites. I saw this response and just modified the values for my use and it works...

Hi, I am trying to create a tracking spreadsheet and i need help coding my submit command button. I know how to submit data into a generic spreadsheet but my problem is i want it to submit into a table i have created. What i am looking for is: When selecting the address in the user form, the...

Greetings wise one, I am trying to make it easier for the users of my spreadsheet to add numeric values into a row of 30 cells. Sometimes they put in a single value (such as 17.29), other times they put in the sum of two values, (such as 17+29). Like most primates these users are intent upon...

Hi The image above shows what I need to do but am struggling with. I need to transpose blocks of data into columns, but don't want to transpose each block manually. Ideally, I want the data from the left to automatically separate into columns (so first one A1 -> B1, A2 -> C1, A3 -> D1, A4 ->...

So I'm super new to VBA :eeek: (hey but I'm learning!) The goal of the code that I'm writing is to create a simple database to track new corporate accounts and sales based on office location. (So nothing fancy). However, as the user fills out the user form, it only fills out the first now...

I'm new to VBA, and any recommendations on where to learn more would be greatly appreciated. I have a spreadsheet where various employee's will fill in the date the complete their assignment, then it flows to the next person. I am trying to use VBA to create a "username" stamp for multiple...

Here's a total newbie problem that I could use some help on: I'm trying to create a list of items that allows me to tag each item with essentially unlimited tags and perhaps a limited number of other fields. Later, I'd like to be able to search that list for specific items by the tags that they...

Good Afternoon, I'm relatively new to VBA and macros but I'm enjoying the journey. I am experiencing issues with a Run-Time error '9' in my macro "Subscript out of range." The debugger identified this line as the issue: With ActiveWorkbook.Worksheets("Incoming_Request_Detail_data").Sort After...

Hello! This is my first post to this website! I have been lurking on here for sometime now... I have been dabbling with macros for a bit, but this is my first major one I have tried to construct/meld together from what I have seen online. I am beyond stuck and close to giving up. I am trying...

Hi, I am very new at VBA and have been exploring it to help automate a form I need to compile everyweek. After deleting worksheets indexed 4 and above, the code should reach in the same directory as the activework book and open specific files as outlined by source1, source2, source3, and...

Hi there, I am in charge of aggregating a lot of information into a document every week for my job, and I decided to create a series of macros to automate most of the process. The first macro I created goes as follows: open a window in chrome, go the company website, scroll down, copy some...

I'm a new member to the site and need some help with a few things. I am relatively new to excel and thought that this might be a good place to start. I have made a set of pivot tables and want one slicer to control them both, I have tried using the pivot table connections option that is...

Hey guys, let me start off by saying that you lot, are GENIUSES. This forum has saved my *** so many times and has really helped me learn alot about excel. Today, i have a new challenge. One that I'm really not sure how to deal with. I have a dynamic set of data, loaded from a server. The...

Hi, and thank you in advance for your help. This is probably pretty simple for someone who knows what they are doing! I have a range, K4:W63. I want to divide each cell, by 1024. For Example =K4/1024; and have that value placed in the cell of K4. Thanks again for your help!

I am a beginner in VBA</SPAN> The main objective is to create a, UDF with 2 parameters (Currency, Date) in order to display currency exchange rate based on the currency and date. Let’s say I want to find an exchange rate between USD/ EUR, then I would have a formula something like “=FX(EUR...

OKAY, so after picking around I figured out how to make a drop down box. The drop down box is in cell E3 (EFGH3 if merging matters). I have 21 values assigned to the drop down box which are coming from cells B61:B81. In cells C61:C81 (technicaly CD61:CD81 again, if that matters) I have 1...

I have some coding experience, but never attempted anything like this in Office 2010. Essentially I have an excel worksheet functioning as a database of service records. Nearly 10K rows/records, with 'Customer Name, Contact, Phone, Invoice #, Product ID, Model, Desc, Make, Lot#, Service Date...

So I'm trying to create a spreadsheet for my summer budget as I am college student that isn't making a lot of money over the summer. I seem to have everything correct except two rows. These two rows rely on an input that I plan to update. Rows 10 and 11 deal with how much I am paying myself for...

Hi folks, long time lurker and this forum has been a great help, but now I'm stuck, I'm signed up and hoping you can help with what should (in my head) be as easy as pie, but I'm stumped :( I have a basic 'resource required' table that tells me what various resource I need and for how long...

I've been learning how to use conditional formatting and decided to apply it to my bank account records that I have stored in Excel. I wanted to check for missing sections in my statement in case I lost any transactions when exporting the data in little chunks at my internet banking website...