help data macro vba copy

Hi All, I am trying to use VBA for the first time and using some videos to learn but I am having some trouble and thought i'd ask experts here for help. I have a folder called output data with 50 workbooks in it all with the same data ranges in it. I would like to consolidate all of this data...

Hello, I have created a front-end user form designed to transfer data entered, across to a worksheet using a macro button. This works successfully, however a number of the columns in the destination worksheet include formulas. When the data is transferred, the formulas are wiped and the data is...

New to VBA, using Excel 2013. I am trying to select a rage columns and rows to copy and paste and transpose into a new sheet. I have searched for anything close and have not been successful. I am including my raw data then a generic walkthrough of what I need the Macro to do. My issue is, I need...

I am creating a break calculator which will help user to keep a track of his login hours and break time. I have already created a the excel file Please find below the format. <colgroup><col><col><col><col></colgroup><tbody> DATE 08/01/2018 Login Time 09:30:00 Logout Time...

I need a way to copy the value of multi cells that pertain to a specific list of 3 digit numbers that can either be paste to a new worksheet or paste to a column as a long list on the same sheet doesn't matter to me.. example colum a has a list of 3 digit codes 555 ,444,333, etc next to the...

Hi. Here is the code I've created: Windows("Banana Republic (99316).xls").Activate Sheets("My Favorite Store").Move After:=Workbooks( _ "My Favorite Store Macro.xlsm").Sheets(1) Sheets("Controls").Select The goal is to be able to manually download the Banana Republic...

This is what I have =IF(AND(OR((Descriptions!B3="x",Descriptions!C3="x",Descriptions!D3="x"),(Descriptions!B3="",Descriptions!C3="",Descriptions!A3=""),( Descriptions!B3="",Descriptions!A3="", Descriptions!D3="x"),( Descriptions!C3="",Descriptions!A3=""...

Hi, I am a very new employee in the company and just started learning VBA. Now I have a project to write VBA code and create a summary sheet by dumping tons of data from multiple workbooks. Here are some criterion I would like to meet: 1) I copied value and date(like 09/08/2016, Sep 8, 2016)...

Hello! Is there a way to calculate a sheet until a cell is ≠ False in VB? I have cells Q92:V92 with IF statements "=IF(AND($O$101>98%,$O$101<99%),$B$99,FALSE" I just want the sheet to continue to calculate until one of those cells becomes true and displays a number instead of constantly...

Good Morning, I have two Workbook's Quick Test1.xlsm(Source) & Test.xlsm (Destination) , i would like to have a button on the Test.xlsm Sheet "Master" that once clicked prompts user to search for a client name, it will then search the closed workbook Quick Test1.xlsm Sheet "Companies" for the...

Hi, After some help with excel to word macro, trying to populate letter templates from raw date pasted from another system. Word templates all <tbody> Title First_Name Surname Address_1 Address_2 Address_3 Town County Postcode </tbody> ---- Code im using Sub FindReplaceInWord()...

Hi I was wondering can anyone help me with this problem, I need a way to calculate the max, min, average, median, mode, amount of numbers, amount of positive numbers, amount of negative numbers, amount of numbers that are equal to cero, the sum of all the positive numbers, the sum of all...

Dear all, First off, thank you in advance to anyone who posts an answer to this question - I really appreciate your help! I am using Excel 2010 to try and make a macro that will try and automate a rather tiresome process of creating many excel workbooks with certain information extracted from...

Good Day, I am currently working in a workbook which uses a macro. The Macro uses information input on a Data Sheet and a Template to populate any number of spreadsheets based on the data populated on the Data Sheet. This is very useful; however, I am also in need of modifying or using a new...

Hi all, I've been reading through the forums quite a lot lately searching for a way to do an "autoprint" for labels from a set of data. Hopefully someone here can point me in the right direction. I am attempting to populate a discontinuous set of cells on sheet1 "T_STICKERS" with a range...

Hello Guys, Please help me.. I have large data in Excel sheet in following format <tbody> A 32423 2234325 12131 11231 2534R 323422 1245 224241 112125 21212 353453 464363 545352 12423 123525 22424 B 114343 12342 2E23R 1342 1423R 25346 1324 1234 2525 1234 2522 </tbody> I want to...

Hi Everyone, I have 21 workbooks (i., 1.xlxs, 2.xlxs......21.xlxs) each with 8 worksheets(sheet1,sheet2....sheet8) I am trying to merge the data from all the workbooks into 1 workbook. The resulting workbook also contains 8 worksheets and the combined data from the workbooks for each sheet...

Hi, I'm new to this and I hope I explain this the right way. I've managed to write two index arrays, one to find the first cell with a number and the last cell with a number in a row range and populate each of these to a cell: range is N5:AR5 1st cell with number populates to F5 per array in...

Hello, I have an issue whereby there are two columns of data that I need to essentially "roll-up". The first column is a list of IDs, and the second column is a list of names. The names listed are duplicated and are assigned to multiple IDs. The end goal is to have a new tab in an excel...

Hi, I have a macro in one of my excel files that basically selects a list of cells from another page in the workbook and pastes those into the active cell. (it is a list of locations and nominal values) for example I would run this macro and paste it into say cell H30 tand it would fill in down...