placing

Hello All, I'm new in the macro space and I'm pretty sure this question has been asked before. But I have multiple worksheets (12 in total). That need to all be gathered in a single sheet. Now, I'm able to consolidate the files it's just that my problem is that the placing of each sheet is...

<tbody>#DAE7F5[/URL] "] A B C D E F G H I J K L M N O P Q R S T U V W X 1 Header Row 1 2 Row That Needs Header xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx 3 Row That Needs Header xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx...

Hi Using the above notation: Sheets(x).Range(xx).select produce a run time error 1004 select method of range class failed. I have a VBA taking data from sheets(x).range(x) and placing it in sheets(y).range(y) What should be the correct notation for this simple task?

Hi Experts, Is there any way that I could use a single formula to loop the C column instead of placing the same formula with different Cell A values for cell C4, C11 & C17? Million Thanks! Best Regards, James

hi i have taken ownership of a workbook . I need the VBA to run upon opening the file can someone advise on how to do this? I thought I just had add the applicable into 'thisworkbook' but it does not run upon opening:banghead: MTIA & KR Trevor3007:cool:

Hello guys, Not really sure what sort of formula I can use for my data. Is there any way I can separate each email addresses listed in a cell? Example: A1: holger@kodal.comtotto@kodal.netsoren@kodal.ukfrede@kodal.dkrie@kodal.netkodal@kodal.netfrede@kodla.se Normally each email address ends...

I have placed the below code in the form's after update event. It works but unfortunately it triggers the print again if the navigation button ( move next or move previous) are used to view that record. Where should I be placing this code so that it will only print the record initially when it...

I have a sheet that needs to compare several (10) columns and approximately 20 rows of data they are not next to each other and I am currently trying to use '=MIN(IF((F7,P7,Z7,AJ7,AT7)<>0,(F7,P7,Z7,AJ7,AT7),"Nope")) it isn't working. I was wondering if named ranges would be better but I would...

I have a DB that contains over 50K records, and I need to look at the data in column G and write in column H what type of data, I have the following Formula that get almost all the data defined =IFNA(VLOOKUP([@Column1],$J$3:$K$24,2,0),"PROD") However I have a section of data that if it starts...