copy formulas

Hello everyone! I create Userform with this tutorial: Fully Automated Data Entry Userform - TheDataLabs Here is main code: Option Explicit Sub Reset() Dim iRow As Long iRow = [Counta(Database!A:A)] ' idetifying the last row With frmForm .txtNR.Value =...

I found some previously solved posts that are similar to what I need, but I am having trouble making their solutions work for myself. I would really appreciate anyone's help! Here's the scenario: I have created a report that holds the grades of certain calls that have a corresponding reference...

I'm trying to duplicate a formula from one cell to all the remaining cells below. I want one cell to remain a constant fixed value in the next cell with the formula using the adjoining cell. The adjoining cell needs to increase in the next cell with one value remaining constant. I know there...

Hey again! Really loving this place. I have a macro that extracts text from multiple worksheets and places it in a column along with the cell reference and worksheet name. I'd like to do the same thing but instead of text I'd like it to pull formulas with text only. Some of the formulas have...

I am looking for a function to copy lines based on a number in column C, for example if column C has a number 2 copy this line 1 time so i have 2 same lines, if column C has a 3 copy this line 2 times so i have it 3 times, i have a worksheet with 300 lines.

Hello all, I have a document that I frequently use for making calculations for quotations. I always use the same formulas in each line for this document with different operations in the columns. To have an overview, I have split these enumerations into phases and subphases. To avoid errors...

I want to copy a formula down. The data is dates between 02/01/2009 and 14/12/2009 but only want every Wednesday and Saturday. I have put in the first few and trie to copy the formula down but excel just copies the five or so I have put in and pastes that over and over again. Is what I am...

Hello Excel Gurus! Hopefully I can explain my dilemma, a bit of background: it's a supplier score monthly tracker, very basic, list of suppliers in column A then Jan scores in column B, Feb scores in column C etc etc. I've been working on Macros for arranging by score based on the last...