formula & macro

My workbook is broken into 3 separate sheets, #1 I am entering in a daily amount of different bundles and or products which each have their own cell. This string of data is essentially copied to sheet #2 and deleted from sheet #1 as sheet #1 's only responsibility is the daily input. Sheet 2...

Hello Everyone I have been assigned a task to create a auto fill function. The task is I need to create a formula to search a particular alpha numeric word in a column and define how many times this word as appeared in that column. For example lets say a alpha numeric word called "MIKE1" in...

Hi Guys, I'm trying to work on a macro but I'm just recording it and here's what I got: Sub Macro1() ActiveCell.FormulaR1C1 = "=VLOOKUP(C1,PvA!C2:C17,16,0)" Range("AB5").Select Selection.Copy Application.Goto Reference:="R10000C28" Range(Selection...

I have a dynamic range, it changes all the time, and every time a value looks like so: #####-### (or in my formula I put ?????-???), I need this formula: =IF(COUNTIF(A2, "?????-???")>0,MID(A2,5,1),"") to be placed in the corresponding row in column C, because I need to extract the 5th number in...

I have written VBA code to hide specific ranges in 4 different tabs in my workbook. I am looking to add another range to the code that would hide rows based on cell value in the same range on each of the 4 different tabs. If the cell in range B9-B13 is blank, then hide that specific row on...

I have a workbook that has 14 total tabs and I am looking to write VBA to rename only 4 of the 14 tabs. The tabs to be renamed will use cell values on a different tab that contain no illegal characters or length restrictions. I have researched how to write the code, but only found the cell...

Hello I am pretty much a VBA rookie, but learning a lot in the last month so please talk to me like I am six and explain as much as possible :) I had a thought about putting in a couple macros depending on if a cell is blank or has an "X" I want to have a macro ran depending on which option is...

I have my Macros working well but need to make it paste a formula in the active cell. I've looked at several posts but have only become more confused. Still a newbie - I've mastered copy/paste and slight tweaks but this is confounding me.:confused: My formula to include is...

<colgroup><col span="5"></colgroup><tbody> <colgroup><col style="width:48pt" width="64" span="5"> </colgroup><tbody> I need to split data, i am having 24 hours data. the time interval also included in that columns. for example, input...

Hi group, I am working on a spreadsheet that has a row of formulas that are from the range ("BB4:BX4") what I am trying to do is get a list of the cell location and the formula within that cell. Anyone have any code that can do that? I would need the results on "Sheet1" in cell A2. Example...

Dear all, This is my first time here. Could you please advice me with this question? Each worksheet called "Project 1, 2, 3, ...., 10" and have 5 questions which each question has drop down to choose 3 variables (YES-2, PARTIAL-1, NO-0). And I want to sum all of 15 questions in another...

Hi, I'm looking to use a macro to drag formulas from the end column to the next blank column and then paste values on the previous column. For example, column V contains the formulas at first. I want to then drag these formulas into column W and Paste Values in column V, but I want to write...

Hello all, Please help. So I have one column of information that is inconsistent to say the least. It has different spacing, hyphens, wording. Essentially it is a comment box filled with different information. What I need is a script or mechanism to only search certain numbers and text 1) 2...

hi everyone, so this code, which I've used successfully in the past, is failing me today: Range("L2").Select ActiveCell.FormulaR1C1 = _ "=VLOOKUP(RC[-9],'[PAID INVOICE Q4-jj.xlsx]Sheet2'!C1:C5,4,<wbr style="display: inline-block;">FALSE)" Range("L2").Select...

Hi, I'm new to this and might not explain this the best,(see example below) Column a has duplicated information multiple times, i need to display column b horizontally see column c , this is the result i'm after. Please ask for anymore information, I look forward to seeing if this can be...

Hi All, I have two questions about Excel 2010 that i just cant seem to wrap my head around. the first is with Conditional Formatting for some reason my Excel wont format over a formula i am trying to run a true/false scenario where if the outcome is 0 it will go red and 1 go green here is my...

Hello, I am using a formula in excel that goes as follows: =SUM(E15,D15,C15) Very simple and works. I have this in Column F and for every cell in F it sums columns C, D, and E on the same row. What I am wanting to do is have this formula look at column A and if there is any data present to then...

Hi All, Got an interesting query to ask.. Trying to work on a formula for the below, I need to remove duplicates that match on the same day.. So if the day and month is the same and the column c letter is the same then remove the duplicate. I cant seem to find a function or macro that could...

I want to copy and paste from one excel to another using copy and paste visible cells only as I have a filtered table between a set range. I'd like to do this through save CSV but this does not possible thus far. The code below works but it doesn't seem to copy paste visible cells/filtered...

Good afternoon, Thank you for reading my post. I have imported over 1000 documents into one master document by a VBA code of copy and paste to create a database. The database has rows of data each with their own headers and and metadata below it. Example: <tbody> Header 1 Header 2...