copy & paste cell

  1. D

    Copying Data over from one workbook to another issue

    I have two workbooks for my code, one is a database (The "Changes" sheet in my example) and the other is an input sheet "(Codename "Sheet1" as my code is being written inside this workbook where Sheet1 is). I am trying to have the code check if the value of certain cells in column "K' of Sheet 1...
  2. J

    Update column in worksheet based on criteria with data from another worksheet

    Hi there, I'd like help creating a macro that allows me to essentially copy and paste information from one worksheet to another based on criteria that will save a great amount of time were it done manually. In the main worksheet I have a column labelled 'Reference' and a column labelled...
  3. S

    Copying cells from one worksheet if their value matches cells in another worksheet

    Hello! I have Googled and searched the forum here, but I haven't been able to find the exact solution I'm looking for. The context of this request is that I'm doing a database update. The source of the records includes addresses, some of which have firm names in them, some of which do not. Our...
  4. S

    Copy/Paste cells with varying row lengths

    The export data I have has Employee name as first row, then one to many rows of data, depending on the employee's activity. I need to move the employee name down to the row of data that has the totals. Each month the row counts will differ. For example, this month I want to move A1 to A23, A24...
  5. T

    Copy filled cells in a column to empty cells below - until the next filled cell occures - and so on

    Hi. I have a table with a column A containing filled cells and empty cells. I would like to create a VBA that copies the filled cells to the empty cells below, and when a new cell value occures, this will be copied to the next cells below etc. until there are no more values in column B. Would...
  6. C

    VBA Loop to Create and Save Multiple Workbooks and also import client names and totals into document

    Hello, I am in need of a code to create and save 93 excel client reports and also insert client names and totals into the report (specific cells). I currently have an excel document that is the template report and another document that lists client names and total amounts. I'm hoping there is...
  7. H

    Data copy from one sheet if any changes to the fields in the dataset

    I hope you can help me with on requirement, I have 10 columns data in Sheet1 and during my working, I can change any data in these columns...but usually, these changes anywhere in the row...same data in Sheet2 and whatever changes to in sheet1 should automatically replace the values in Sheet2...
  8. G

    Copy data from one file to the active workbook in VBA

    Hello everyone. I've been struggling trying to copy data from a file that I download on a regular bases and paste this data in another workbook. I created a loop in order to select the downloaded file from the folders, after that I try to select the data I need and then paste it in the active...
  9. A

    Identify last cell data in a column and paste the same in all above cells

    Hi I am searching for a VBA that will perform to copy the last cell data in a column "A" and paste the same above all the cells in that same column "A" in that same worksheet. Kindly help. I have provided a format here. I need to do this operation for 100 + files . So kindly provide some...
  10. U

    Copy Columns from one workbook and paste into specific cells in another workbook

    Hi, i am searching for solution but not getting exactly what i am looking for, i want to copy specific columns from one workbook to specific cells in another workbook, and also want to rename workbook and sheet automatically by getting today's name as workbook name? copying column from one...
  11. M

    VBA Copy & Paste last row with formula, then copy & Paste the row above as Value

    Dear Sir or Madam, I am looking for a VBA Excel Makro with the following action: I have an excel workbook with many sheets. They are all set-up the same way. I need to copy&Past always the last row within a sheet with the formula and copy&Past thereafter the row above with Value within the same...
  12. W

    Copy Cell Data into master sheet based on cell value

    Good Evening All, I am creating a project board which has a master dashboard sheet. The idea is that each individual project has its own sheet in the workbook and these are assigned a project number. Then in a weekly meeting I plan to pull together headline information from the individual...
  13. P

    Copy and paste selected cells only

    Hi. I want to copy certain cells from a row and paste them in the corresponding row numbers, but in another column. For example, I want to copy cells A1, A7, A28, A2000 and paste them in D1, D7, D28, D2000. When I select cells A1, A7, A28, A2000 and paste them at D1, cells paste adjacently...
  14. S

    Copy Data From One Cell to Another Based on Data in a Third Cell in Multiple Sheets

    I have a spreadsheet which has 10 worksheets, starting with the third worksheet and all those which follow I need to evaluate the data in column K to see if it contains the following: Approved CTO or Approved-STM If column K contains either of these I need to look at the cell in column L and...
  15. T

    taking multiple inputs userform VBA

    I have multiple csv/xls files that i want to browse from user form then get specific cells data from them and copy to specific cells of already present workbook with formulas which want to browse again from user form and get output to a folder. I have multiple batch of 4 files in which i...
  16. A

    Macro/VBA to Copy and Paste cells in same location

    I need to make a macro/write a VBA code to select from a range of cells, say H8:AQ117, all cell values greater than 1, and then copy and paste them (paste Value only) at the same location without their formula as I want those particular cells to remain unaltered as I change the values at their...
  17. W

    Copy cells next to specified 3 digit code

    I need a way to copy the value of multi cells that pertain to a specific list of 3 digit numbers that can either be paste to a new worksheet or paste to a column as a long list on the same sheet doesn't matter to me.. example colum a has a list of 3 digit codes 555 ,444,333, etc next to the...
  18. S

    Excel Crashing after copying comments over

    I have been trying to copy comments over using VBA and every time I do it will work until I open the excel file again and then it crashes. I don't know that it is a problem with the code but perhaps how the pictures are viewed. I have them as comments with the background being pictures...
  19. K

    VBA ro copy 2 cells if condition met

    I have the following code which works well but i now need to copy J & K if the condition is met I have tried a couple of ways but cant get it to work so use same module but for J it would be much quicker if i could do them both together as there are often about 4-500,000 lines of data but on...
  20. P

    VBA/Formula Combo returning reference error (#Ref) Excel 2016

    Hi all, I created a workbook with 7 sheets (a master and one for each person on my team). The sheet is meant to track our commissions. I used a VLook Up Formual to match the product with the commission rate (the table is on sheet 2). Everything works on the master sheet. However, I also put in...

Some videos you may like

This Week's Hot Topics

Top