moving data

  1. L

    Moving/managing data between different worksheets

    Hi. I'm a noob in this vba stuff and I need to solve a little problem. I have a worksheet named "File1" where I have some sales data and the same with a worksheet named "File2". I have 3 values among all the columns (val1, val2, val3) that I need to compare between the two worksheets. If the...
  2. M

    Help - VBA code to move certain info from a Master Sheet to new sheets

    Hi All, Looking for some help with a VBA code. Each day I get a data download from one of our systems which compiles all completed, ongoing and cancelled cases. I then have to manually go through the data to sort into 3 new sheets within the same workbook. With over 20,000 of data each day...
  3. L

    Moving data from one cell to another

    I generated a report and would like to move the data from one cell to another. I have data in Column J3 and would like to move it to K2. Please advise. Thanks. -- removed inline image ---
  4. T

    efficient code to move group of cells from one tab to another

    hey guys, I have a tab that has main info. The tab has the code below to filter out and create new sheets based on a word. I am trying to get certain cells from the output to be placed in corresponding cells within other tabs instead of random sheets. how can I have the data go from the main...
  5. M

    Macro to move rows in worksheets not working as expected?

    Hi, we have used the following macro (its in 2 parts one to copy the other to delete from the original tab- because when we ran it all together it caused even more issues!) to move data based on codes onto 3 separate worksheets (active, completed & Cancelled) however when we run it only moves...
  6. M

    Macro to recognise a code and move all rows of data from one tab to another...

    Hi guys! I need some help I'm a bit of a novice and have never used Macros (I've tried to work it out from other posts but I'm stuck). I have a sheet which has rows of information on tab1 from column A2 - J2, in column J2 at the end we input one of 3 codes or N/A. What I want it to do is if i...
  7. S

    Help Moving data down 1 row

    Hi there.... I'm new to this forum so be gentle. I have a Rental Form that i'm working on, and to tidy things up when I print it out, I would like to move a cells data down 1 row if that cell is empty. Here's what I have: cell b8 - First and Last Name cell b9 - Address1 cell B10 - Address2 cell...
  8. A

    A moving auto population of cells based on date

    Hi, I have learnt so much from this forum and have reached the point where I need to ask for some help! I am working on a workbook whereby the data needs to be stored each week in an archive sheet. Is there any way of doing this automatically? If this could be an action that is performed...
  9. A

    Formatting and moving data to another sheet via Vlookup? or VBA ? or Something Else

    Hi I am currently trying to produce a spreadsheet for an entry system to sort out swimmers in a gala by events they have entered. Currently I have the main entry sheet which I receive back from each swimming club, with the details entered, Columns F to J are y / n answer if Y is selected the...
  10. H

    Taking Action Based on Day of The Week

    Hello, Let's say I am selling a weekly newspaper @ $1 each (retail), and I purchase 10 newspapers at the wholesale price of $0.25 each. During the 7 day week — Wednesday through Tuesday — I sold 8 newspapers, leaving me with 2 leftover papers from that week. So, when the new newspaper comes out...
  11. S

    error 1004... moving data from first col to another (variable) column... complicated simple problem...

    Hi guys, I have a column of data down my col B, and then more data staggered in various columns further to the right on my worksheet, I'm trying to write a 'simple' <.< *grrr* script to move the column over to the cell one to the left of my other data. For example, if this is my current sheet...
  12. M

    VLookup

    how do I use VLOOKUP to move whole columns of data from one report to the other.
  13. Q

    Dropping data into Label

    I have a workbook with numerous sheets, few sheets have data in standard rows and columns, one sheet has a label/tag setup such as : Date:___________ Name:__________ Style:__________ Number:________ Is there anyway to highlight a row of data from another sheet and drop that information into the...
  14. P

    Need help with If Function between sheets

    I am trying to simplify having to input fixed information. I have information on two excel sheets/tabs One sheet is where i want to input data the other sheet is where i want it to grab the info. So if I put in 3 in A1, it will look on the second sheet and grab a number from B3 and place...
  15. C

    Moving Data into another sheet

    Hi Everyone I need a little help, I have a sheet which contains fairly simple data in a Sheet called "Trade Planning", it contains data in columns A:T, each of the rows has a mixture of Manually input data and formula, two of which reference a sheet called "Contract Calcs" for some data needed...
  16. K

    moving data

    Hello, I'm using XP & excel 2007 pretty much just learning. I would like to move data from many cells in the same column at the same time. The cells are separated by other data or blank cells. There are many cells in the column to move at the same time, so moving them 1 at a time takes too long...
  17. W

    VBA macro code to move data from one Excel Worksheet to another Worksheet within the same Workbook

    Hi All, I am a beginner in VBA Excell scripting. My requirement is as follows: I have a Excel workbook with two sheets - 'MainDataSheet' and 'ArchiveSheet' . The 'MainDataSheet' has 5 columns and one of the column is 'status'. The 'MainDataSheet' will have a command button 'MoveData'...
  18. F

    recording a real time data.

    Hello , i want you to help me now. How we get an updated list data entries directly from a running and real time recording? example: Day 1st Time Name Buy 07.00 John 5 units 07.30 Smith 2 units 09.00 Alexa 3 units 10.15 John 2 units Day 2nd Time Name...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top