move data

I have an array of data that has 28K rows in it. This array is for Production BOM's. The data has columns of Production BOM (C), Description (D), Component (E), Description (F), Supplier Name (G), Supplier Part No. (H), Quantity per (I), Unit Of Measure (J), Supplier Number (K) What I need to...

I have two sheets in a workbook, where the first sheet has a column which has a couple of teams. I created this script that loops through the columns on sheet 1, and copy the team name, and some data around it. Once copied, it activate sheet2, and paste the 3 columns copied from sheet1. Now...

Dear all, I am a beginner here. I would like to ask a help for someone who can help me to solve the problem. I have around 800 data in excel and I want to move data from one column to different column and row. It is difficult to say here, I will give the example in the table below. Please...

Hi! First time poster, and absolute amateur at Excel ? I've been trying to work this out for a while but I really don't know where to begin, so apologies if this has been asked in other terms. I need help transposing the contents of one sheet into another sheet where the columns and rows are...

Hi, I have an excel(attached) file with 2 Tabs (Data, FinalResults). "Data" tab has a Table (Table1) which will have some data. the "Data" tab also has a button, which when clicked copies all the the data from Table1 and pastes it into "Table2" on the second tab (FinalResults). and following is...

I'm not really sure what the correct name is for what I want to do, so here's a description. I have an Excel sheet where column A has, in some cases, the same value, but column B is always different. I want to move the secondary column B values to column C, Column D, etc. so the values are all...

I am trying to move data in "Sheet 1" into newly created tabs. These tabs are created and named based on a list of values. These can change once opening the workbook. For example, we might create tabs A, B, C, D, E and the next day these tabs could be F, G, H, I, J. Now, I want to move data in...

I have one sheet with 3 (A:C) columns. Where column C contains the value 'Y' I'd like to move the entire row to compile a new data set in a second sheet. Both sheets have header rows. Eg. mudmap below Sheet 1 : how it looks [/URL][/IMG] Sheet 2 : How i'd like it to look! [/URL][/IMG]...

Help me create macro. Compare Sheet2 with Sheet1, IF match paste result into sheet1. Sheet 1: <tbody> 1 a b c d e f: Result 2 Name John Name Name Name John 3 Paula Name Name Name Name Paula 4 Name Name Rick Name Name Rick 5 Name Name Name Name James James 6 Frank Name Name Name Name...

Hello forum members, I have a simple problem but I really really really need your assistance. Before posting this new thread I have done extensive search on google for 'move column' 'move data' and couldn't find what I was looking for. I have a workbook with 2 worksheets "Data" and "Ledger"...

Hi, I have almost 70 employees monthly login/Logout data in one sheet. I want to create new sheet with each unique value and move the monthly data into there. Here is a screenshot: Screenshot by Lightshot Is it possible to make it by using ASAP utilities? or Please help me with the VBA...

Dear All, Need your support - am trying to move data based on multiple criteria in 3 columns to be moved to another sheet, Sheet header is located at A6 : AE6, Criteria located in J6, N6 and O6, Main Sheet name is "Raw" and the new sheet named "New", Really appreciate your input, Thanks, MK

Hi, I have two tables in two different worksheets under the same workbook. Table 1 & Table 2 I want to create a function that will take table 1 & table 2 as parameters. Copy cells from table 1 to table 2 but we have have 2 questions: Which column to update and which row to update to know the...

Hello All. I am new to the form and will appreciate any help. A quick overview I have never coded in excel (macros, VBA) but have used MatLab and C so i do have a descent understanding of code. The easiest way to explain it will be to add the table I'm working with the first table is the...

Hello. I was searching how to copy-paste an entire row that contain about 10 different columns, but with a button. the thing is that also I need that when I paste a row, then I need to paste the next row below the old one, like a form. for example: the rows contains measures by week. I need...

Hello, I am very new to VBA and am looking for some help with something I'm trying to figure something out. Here are some details: I have "Table1" in a sheet called "Interviews" I have "Table2" in a sheet called "Main" "Table1" Stats: Columns A-I. Headers on Row 4 and first Data row is 5...

Hi everyone, I'd like to explain what this table needs to provide. We have the monthly revenues by product, but the billing time for that revenue is a number of months away. How many months, depends on the product. So, what I need is for example move January revenue of Product A (let's...

Hello, I need to do two things, can be two seperate macro's. 1. I need to insert a blank row every other row in a selected range. 2. Then I need to move the data from Column G into column B in the newly created rows. The number of rows I have varies each month. Sample is I have 80 rows of...

Alright, so I have been trolling the Intertubes and came across some VERY helpful code from this very forum, so it seems reasonable that the proper thing to do is ask the question in this very same forum. What I have is a bunch of little routines to conduct simple Find(s) & Replace(s), as well...

I'm in need of a macro that will move data from a group of cells in a column to a different group of cells if the information is empty. Is there a macro out there like that?