sheet1

Hi is there a way besides using .Formula to say sum all the B6's on the worksheets in a workbook expect for sheet1, and put the results in B6 on sheet1?

Hi - everyday i always have 3 sheet (sheet1, sheet2 and sheet3) and need to copy to new workbook. but before that, i need to rename it with - sheet1 = backlog approval - sheet2 = backlog release - sheet3 = backlog pr instead using manual effort, can you please help to create vba macro to run...

Hi, can you please help me with this. thank you I have 21 worksheets I will refer to all my worksheets by codename Cells A2 through A21 of Sheet1 contains a list of PO Numbers. I want worksheets 2 through 21 to be renamed based on sheet1 cells A2 through A21. example : if Sheet1, Cell...

Hello! I have the following code below and it works great but I need to add to it if possible! I am running a macro in sheet1 on active cell column C and matching it to sheet2 column B cell that works fine. But what I need now is when the match is found on sheet2 column B I need to copy the row...

Hi All, My simple dynamic chart works great when using the original data located on the same Sheet (let's say this is Sheet1). I'm Naming my columns of data using the Name Manager along with OFFSET in the Refers to field. I have up to 13 tasks in column A, then Start and End Dates in columns...

HI i am new here my name is Christy, I joined this site because i am having trouble with a particular VBA code I want to take information from cells in work sheet2 and put it into work sheet1 last row which already has 1865 rows full of information The Range from sheet1 is B1-B9, (which is a...

Please can someone help me 'tweak' this script that I am using to apply a macro to all tabs within a sheet - I would like the process to exclude 'Sheet1' from the process (so that 'Sheet1' remains as is- thank you for your help. Marc Sub Dosomething() Dim xSh As Worksheet...

Input Range C2:C8…ONLY 1 cell contains Non Zero value Output in D2 as Non Zero Value from C2:C8 How to accomplish? Thanks in advance Sheet1 <colgroup><col style="FONT-WEIGHT: bold; WIDTH: 30px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"></colgroup><tbody> C D 2 0 588 3 0 4 0...

Hi everyone, I've tried reading a lot of articles in excel support with no luck. I am trying to do a sumif formula but i keep getting a zero when there is clearly data to be calculated. I have two pages I am trying to calculate the field on sheet2 column $H2:$H20000 The cells need to look for...

Good day all, I have an uncommon challenge. I have a sheet named Sheet1 filled with data, I want a situation when I delete the values in a cell, instead of remaining blank, it will be filled with a string (example "x"). I tried using the IF function from Sheet2 to fill a blank cell in...

Hello, I have found a few different solutions online for this that seem quite simple but just won't work for me. I need help please. I have a column (F) of values, text, and blanks on Sheet1 that I need to copy the values of every 5th row into a new list on Sheet2 starting with F3. I have...

Having issues once it comes time to reference another sheet. So each device I am trying to find (~300 over 15000 rows) has a specific serial number always in column B. These are on Sheet1. Once that cell is found, there is a set table size I am trying to make, 150 rows long, and extent from B...

Hello, I am trying to set up a simple time sheet tracker. How can I enter start and end times and then total the hours for each task. I tried in the below example but appreciate any help on this. Thanks Excel WorkbookABCDEFGH3Time Charged To4A/NDateAFR NumberShop OrderOtherStart TimeEnd...

I have 2 worksheets.... In Sheet1, I have a list of 100 Static IDs ( they never change ) in Column D. Starting from D11 to D111 In Sheet2, I have a dynamic database ( updated daily ) of about 25,000 rows. Each ID ( from Sheet1 ) will appear ONLY ONCE in Sheet2.ColA. Need a VBA to delete...

I need a small VBA to copy and paste from one sheet to another, with a catch... Sheet1 is the source sheet and has dynamic data ( Numbers ) from d11 to d110. Sheet2 is the destination sheet and the data needs to be pasted in d11. Later... new data is input into Sheet1....this new data from...

i have an advanced filter, but so far there's no relevant data so after the advanced filter, only the header row shows up and the total row (ie the row after all the data) is blank. (currently the total row as of today is 24,000 but it can change daily depending on the day's data....again, the...

hi, everyone i need code automatically delete empty rows when transfer data from userform to sheet1 i have userform when i fill data it does transfer data to sheet1 i would delete rows from after lastrow contains data without effect the values of others cells the basic of range beginning from...

Hi, I have amounts in Sheet1 ‘column D’ and Sheet2 ‘column C’, I want to copy and paste the amount in following tabs in column B and column F with the below criteria. Criteria to be match is date and plan ID (Which is in H1 in all tabs). Thank you so much in advance

hi, everyone i need code automatically delete empty rows when transfer data from userform to sheet1 i have userform when i fill data it does transfer data to sheet1 i would delete rows from after lastrow contains data without effect the values of others cells the basic of range...

HI, good morning, I have the code below where I am trying to copy data from sheet1 to New, but its not working I am trying to copy C2 to last row in Sheet1 and paste into 'New' from B2 to last row and do the number format . please can you help? Private Sub CommandButton3_Click()...