copy/paste

I could really use some assistance to complete this macro. So far, I have a code that will review the value of a cell and insert a row on a following sheet. Sub AddRows() Dim i As Long Dim j As Long Dim k As Long Dim l As Long For i = 1 To 200 If Sheets("S&S Build").Cells(i, 28) = 4 Then...

Dear Experts, I wonder if any of you could please help me with the following dilemma. I’d like to be able to search for a name stored in Cell G3 of the Worksheet called NOTE JOURNAL 3, down on column G, so that if the one is found is not the one I want, when Click on the button, the macro will...

This is a well-known problem though I couldn't find a solution here or anywhere. When a protected sheet has cells which are not locked, but have formatting and data validation, a simple copy/paste into those cells from another sheet loses the formatting and validation in the target cells...

I am trying to Copy Paste data from one cell to another. But paste option is getting disabled after copying and selecting new cell. I am using code for selection change as below. I have not disabled the paste option in code. Private Sub Worksheet_SelectionChange(ByVal Target As Range) If...

if a formula is: ='Game 1'!$C$6 and I want to drag that down in to several other rows, but i want it to game the game number from 1 to 2 to 3 etc... on down the list while leaving the column and row alone could it be accomplished dragging it into different columns (horizontally) as well?

Ok, I have 2 pre-existing workbooks. I need a macro to open WorkbookA, find "James" in Column B, copy value in Column J of that row, go to Workbook B, find "James" in Column B and paste value in next empty cell in that row. Then close WorkbookA Not sure if that makes sense.

I have a large spreadsheet, 32,000 rows X 13 columns and I need to create graphs of the data but 32000 data points is too many. I need to select every fifth or Nth row and copy it to another sheet. I think a macro would work, but i don't know how to write them. Can anyone please help me???

Hi all, I am using Excel 2003 and am having a problem formatting. Specifically, when I copy from one spreadsheet and paste special/values to another spreadsheet, sometimes the formats from the original spreadsheet are also pasted. Why is this and how can I fix it? I have looked at the...