stuff

Hello I have a VBA in a spreadsheet so that all data i enter aligns to the top and left. However when I copy over data from another spreadsheet it seems to override the vba formatting any ideas? Thank you. Sub Stuff() Dim wks As Worksheet For Each wks In Worksheets...

Hi I just watched a video and ExcelIsFun author said Filter() not not available now. He manged to do a lot of stuff without using array function anymore. That is a big change. My second question, is Microsoft going to get rid of array formula? https://www.youtube.com/watch?v=cB6UlIwpwVc

I am new to creating macros on excel, and would like to know where to start. I need to create a workbook to pull information out of another workbook, and put it in different tables based off of the text. Are there macros available for stuff like this, or can someone point me in the right...

How can I go about creating a subgroup listing of the top 2 The data Name a a b b b c c d d d d output to starting range("G15") Top 2 D = 4 B = 3 Even the simple stuff sometimes seams difficult

My macro does things to a file, File1 - a file with a different name every day. Then it looks up some data from a tab in another file and uses that data to do stuff in the first file. At least it should. The ThisWorkbook.Activate doesn't make the macro stay focused on the first file. When it...

Hi, I'm using Excel office 365. Weekly I import data into Excel then filter out certain items based on preset criteria. I do this using auto filter and a simple macro to delete the entire row. So for example, my import might look like this: <tbody> Date<strike></strike>...

I think I may have to create and Access program for 2007. The problem is I have 2013. It's pretty standard stuff but I'm not sure if it will run on such an old version. The Excel stuff I've done works fine. So, am I outa luck or will it still work?

I have a cell with the value 125% in it, however I need to make the cell display the words "INCREASE BY 25%". Example: If cell A1 = 100, from a pull down menu in cell A2, I want the user to be able to select "INCREASE BY 25%". Having selected "INCREASE BY 25%", the value of cell A1 then needs...

So how do I ignore the worksheet named "Data". For Each ws In Sheets if ws.name="Data" next ws end if else 'do stuff here next ws

Yesterday, everything worked fine. Today, now I get the same error on every control I select. I also tried a completely separate workbook (nothing in common with the first except both use VBA) and got the same error! :confused: The only change I made yesterday to bothwork books was adding in...

Hello, fine folk. I have what seems like a complicated formatting problem I could really use some help with. In column "A" I have text formatted in a specific way. In column "B" is some other text. In column "C" I have a concatenation of columns "A" and "B". Super basic so far. The issue is...

broad question but i have a report that ends up being close to 26KB and it takes way to long to open and function. most of the report is based off SUMIF statements, stuff like that any resources, tips anyone has i can use/check to try and make more efficient and shrink the size so the user can...

Hi everyone! Pleasure to have become a member of the community. I hope to become a net contributor to the board in the future. Alas, now I will posting (hopefully) pretty basic stuff. I mostly self-taught myself Excel and became pretty proficient from my former job in benefits (typical basic IF...

Hi, below you can see a part of my code that will do stuff with a workbook so long as it is an xls file. The code searches for the sheet named 'quote' and then does stuff to that sheet. I would like to change the code to skip the file if the workbook does not have the page 'quote'. If InStr(1...

Say you have a for loop that posts stuff for each iteration into cells one below each other. That's pretty easy to do, with say "A" + i. How does one go about doing this with the cell letters, or in other words to put stuff into cells to the side using for loops? Cheers

hey guys, I need a macro to make all data in one column of variable size do this: if data in a cell of the column M is bigger than 900, subtract 900. Afterwards, if the numbers 33 and 34 pop up, they should be changed to 13 and 14, respectively. This is pretty basic stuff, but I don't know the...

I'd like to active a textbox, (or several textboxes) & have a macro that will make it a specific height & width. Is it possible to do something like this? All the stuff I've found deas with autosizing to text.

Hello guys, I am trying to set a formula. The formula that I need Is something: If F5 is one stuff here, G5=to the corresponding stuff in the table below. F5 is the cell with multiple choice the formula has to be insert in G5, were actually there is 160. Thank you.

I will probably be here a few times over the next few weeks to get answers to the stuff I am learning. Function REMOVE(Txt as string) As string Why 2 As Strings?

hello evrybody good morning... i have sheet excel ineed to shere it with my stuff to work online and offline anytime and any where plzzz help me??