I have a excel file with two sheets. Secon tab stored all previosu data and in the first tab I am adding new data every day. I need to comapre dates in column from 1st sheet and 2nd sheet and then copy from 1st tab only those lines where date is greater then in second tab (of course copy and...
I have an excel sheet that contains all of my data named (Book1), and that excel sheet (Book1) updates on daily basis. What I want is to transfer the data for each date to another excel work book (Book2) on daily basis, without over writing the old data on the work book (Book2). For example if...
I currently have this setup, please note that I have hidden all the nonrelevant columns however:
The formula I use is this (thank you @RoryA !)
Hi guys Hi guys, I need a VBA code which will be copy some files from Folder 1 to the Folder 2 . When I search in the internet i found some written solution but they are not exactly what I am looking for.
I want to copy not the all ( B4:B12) files it will be for example only B6, in the next...
I've created (pieced it together from solutions found on this forum) a looped VBA code that currently makes a copy of all the non excluded sheets in the workbook, exports each sheet as a separate workbook, and saves them as a CSV file using the sheet name as the file name.
This is my full code
Dim myWb As Workbook
Dim myRowsToCopy As Range
Set wbtemplate = Workbooks("Template.xlsm").Worksheets("Raw")
Set formatrange = Range("B2:CE2")
Set formularange = Range("AK2:CE2")...
What I'm attempting to do: copy all the rows from an open workbook, insert them into my other workbook that is a template, between to placeholders with formulas. my data in the template goes from A:CE. I've got the first part working where I insert the rows, but I don't know how to paste formats...
Good morning. I read the article concerning this question but the recommended code was not working for my intended application.
I am looking for some help, please. I have an excel table for which I need to back up daily. I want to save new data (values only) each day without overwriting the...
I am very new to excel and VBA. I am trying to:
-Have a button for each row in a sheet called "sheet one".
-On click for one of these buttons, it copies 10 specific cells from the row (say J, H, I, M and L for a given row),
-Putting them in a new entry in a different sheet "sheet two"...
Hoping for some help once again.
I have a table that tracks my rentals:
Company Rented from:
Rental Start Date:
Length of rental
Estimated Due Date:
Total cost of the rental:
I'm looking to edit this script such that if there is no value under the first row and then don't copy it. So only copy the cells with values inside
Can someone help me with VBA code to filter all the values in column B ending with 21 or 22 or 46 in the active workbook and then copy paste data in to the worksheet named "Data" in the workbook named output which is placed in the same folder as the active workbook.
Hoping for some help here, I clearly don't know what I am doing.
Here is the goal: To update my master spread sheet.
I am trying to implement a new project tracker, this will be an excel sheet, named exactly the same thing, for EVERY job.
It has a table in it on a hidden...
Hello fairly new with vba but having some issues... I have a workbook with 3 sheets. Lets say sheet A sheet B and sheet C. Sheet B is a a form with data entered in certain say cell C5 , F11 and G15. In a nut shell I want to make an archive by copying a sheet, rename it, hide it, and clear the...
: hi all,
please help me in the below vba code, as beginner
in the work sheet, just want to insert the multiple rows through input box and insert after which row through input box.
then i make which row to be copied through input box.
i cannot paste the copied row to the number of...
I have taken over a project that someone previously developed the macros for. I would prefer it to work regardless of the dataset being used, but the person that developed it used mostly "fixed" ranges and I would prefer that it determines the range based on the data set.
The beginning of the...
How to copy data from all worksheets in a workbook, into a new single worksheet, creating a new worksheet named "Combined" but not adding them below into same columns (last used row +1), but to the side. First data from the first copied worksheet into "Combined" shoud go into A1, then...
I'm relatively new to this world and I've tried to solve my problem with macro recordings, tinkering with those and hitting up google but I did not yet get the hang of it. While being able to create single, individual steps when lucky, interconnecting several and of those...
So I have been having this same problem for a long time.
I just work around it, by scrolling with my mouse, which can be tedious.
We used to have MS 2016, now we have Office 365. Problem existed on both.
The document is a shared document, old school, not the internet sharing because I need to be...
I am considering to use power query to get data for my pivot table. However, I am EXTREMELY new to both pivot tables and power query.
I want to import data into this pivot table (not using power query below):
I have the source data saved here:
So questionnaire data file 1 is week...