help in need!!

All: First and foremost I just want to say how vital this website is as a tool for someone who is trying to learn without a formal programming education. I have been lurking on this site for months now and in that time I have learned enough to actually start writing my own codes. After reading...

Hi Everyone . . . Not really an Excel VBA expert, so I thought I would come try my luck here. Essentially, what I am trying to accomplish is this: I have two columns of data that I would like to generate, a date range and an hour range. I have the following range of data in Sheet 1 Column B...

Hi so basically i need to loop through the values xo=-7 and xf = 5 For a graph there need to be 21 grid pts ie 21 values between -7 and 5 and i calculate dx to be .6ish Basically I just need help putting this into a loop using variables for the numbers so i can change the xo's and xf's etc.xo =...

Hi, I have got a problem which I dont know how to fix it properly and efficiently. Problem 1: I have a excel file that contain many hyperlinks(each connecting to its own excel file) Is there any way to copy every excel hyperlink in one entire workbook. Problem 2: Once problem1 is solved ...

Hi All, Im pretty new with VBA and excel, Just wondering if someone could give me a hand with writing some code. Im trying to create shapes Rectangles and Squares with different colours within an excel sheet, where the length and height of the shapes is generated by input values. Also is it...

Hi All! This forum has been awesome for getting me started on VBA, I'm not a programmer and I had to pick this up now because the company that I'm working for has a really outdated system and we have to do a lot of Excel manipulation to get the files the way we need them. I appreciate any help...

Hi can anyone please help me with a macro code please I want to hide auto filter on the following columns A,B,C,F,G,N,M,AB,AD But want to show in all other columns How can i do this? been trying all day and i bet it is simple lol i am using excel 2003 :confused:

Hello, So I have a set of Data (lets call it the master set) with mutiple columns of criteria. I would like to set up a tab for each of the "Zones" that are in one of the colums. Is it possible to have the whole line populate in the proper zones tab based on the one criteria? I can further...

I am working with a macro that has old data in it that is not useful for what I am using it for. I was wanting to see if it is possible delete the unusable data that is older than a certain date (always changes). It can only delete the info in column A-G since there is critical info in columns...

Hi, I've got a problem with an IF/And Statement and do not know if this the correct function to use. Basically I'm trying to say two things in Cell E2: IF the date in column C2 is greater than column A2 it is Late, if not its on time AND If the time in column D2 is greater than column B2 it is...

I have an Excel 2007 spreadsheet with 2250 rows and 19 columns. In these rows, I may have two rows of duplicate customer information that need to be combined. I may also have rows of customer data that are not in need of combining. A unique customer member number can be used to identify the rows...

Hi All, Please can you help me! I need some VBA to help consolidate multiple worksheets into one (a 'master' worksheet). I do not have the data to hand. But I have been told every tab has identical columns but with varying number of rows. Also, please note that the data we are interested in...

Hi All, I have a problem where I'm trying to find a formula for the following and don't know if I need to use a V-lookup, an IF statment or something else. I'm basically trying to say ; Sheet 1 A B C 1 From To Date 2 J330 J310 10/05/13 3 J330 J310 10/05/13 4 J330...

Hi All! I'm new here so please forgive any of the stupid things I might say :) I'm trying to create a macro that goes thru all the cells in a row, double clicks them and goes on to the next cell (all the cells already have values in them). When I record this then this is the code that is...

Hi Excel Geniuses! I would like to ask some help in resolving this matter. I am almost done doing this Excel project of mine. Each sheets consists of locked and unlocked cells. Whenever someone opens the file, it will automatically change it's interface to read-only, whereas, it will lock all...

Hi! Is there a ISDATE native formula in excel? I am trying to enter a formula in one cell (cell Z11) in which, it will display TRUE if T11 finds the same value or date in cells B11:R32. Please take note that I formatted cells T11 and B11:R32 as [$-409]d;@ so that it would only display as number...

In my current macro I have ~50 worksheets that I need to open/update links and print in a specific order on a shared drive. It takes me 5min to do all of this. Is there a different combination of variable/commands to print these quicker? :( Here is a sample of my Macro: Sub Sample_Morning()...

To all sifus out there, how can i transfer from these: NAS517-3-2 -41353913 NAS517-3-5 NAS517-3-4 -42MS27253-2 -43353908 -44357182 To these: NAS517-3-2 353913 NAS517-3-5 NAS517-3-4 MS27253-2 353908 357182 Thanks in advance.

Hello Guys, I need help again. How can i change this: <tbody> -10354493-1 ...FITTING ASSY, ELEVATOR, HORIZ STAB STA 180.0 1 /SPARES CONDITION PER PRINT EXCEPT ALL HOLES IN AFT FLANGE DRILLED NO. 40 PILOT SIZE </tbody> Into this: <tbody> -10354493-1 ...FITTING ASSY, ELEVATOR...