All info goes to the master inventory and then if some enters an amount for respray then it is transferred to the respray sheet. when it is transferred to the respray sheet it put the date in Column A and then put 3 days later in Column B.
Every day it will change and the date in A1 changes to tomorrow but if another item is enter as having resprays then it transfers to the respray sheet and will bump down in column C but Column A stays the in the same spot.
I need Column A and B to move up and down if something in Column C moves up or down and it would be nice to always have the oldest date at the top.
I get an excel sheet with W/C Employer: (whatever) entered below the patient it belongs to in column E. This information needs to move into its own column (H) in line with the above patient information so I can use it in a mail merge to word.
The same thing needs to happen with WC injury date listed in column G. It moves to column I. Then delete the row it was moved from so I don't have an empty row.
Sheet 1 is what I get. Sheet 2 is what I need to end up with.
Imagine I have 2 columns of information that look like this:
Column A Column B
AS Dog
AS Cat
AS Hamster
FT Fish
These are my key columns. The letters are initials of people and the animals are the pets they're responsible for.
Now, I have 3 more columns that look like this:
Column D Column E Column F
These columns can go on for hundreds of rows.
What I want to do is pull out the information from columns D, E and F where the initials and pet match those in the key list, then paste that elsewhere (say to columns J, K and L).
So, for instance, the first entry would be copied across because, according to the key list, AS is responsible for a Dog, but the bottom entry for AS wouldn't because he was looking after a fish, and that pet isn't listed as one of his animals in the key list (Fish is listed alongside FT). Likewise, the entry for AH wouldn't come across because AH doesn't appear on the key list at all.
I am trying to use visual basic editor in excel. I have all ready set up my user form where information can be entered, but I ave having trouble getting the information that is entered in the user form into the correct cells in excel.
I am wanting my information to enter the tables and then automatically move into the next available cells below.
Private Sub cmdadd_Click() Dim iRow As Long Dim ws As Worksheet Set ws = Worksheets("details of cars in stock") iRow = ws.Cells(Rows.Count, 1) _ .End(xlUp).Offset(1, 0).Row If Trim(Me.txtreg.Value) = "" Then Me.txtreg.SetFocus MsgBox "please enter a registraion number" Exit Sub End If ws.Cells(iRow, 1).Value = Me.txtreg.Value Me.txtreg.Value = ""
Column A | Column B | Column C Los Angeles | Fire Dept | 3 Los Angeles | Health Services | 12 New York | Fire Dept | 8 New York | Health Services | 22 New York | Internal Services | 100 New York | Public Works | 7 Chicago | Health Services | 15 Chicago | Public Works | 56 Chicago | Social Services | 4
And I am trying to make it look like this:
Fire Dept Health Services Internal Services Public Works Social Services
I have set of data Pasted in 4th row, in the top row 44 columns values assigned i want move data from set of data to different column among these 44 columns
Like "Service Order ID" is 1 column in set of data ,it move to second column of top row
Some of column need to delete. (Service Order Type,Service Order Description,Created By,Status,Contact,Expected Delivery Date,
I am in need of restructuring a spreadsheet of addresses for mailing purposes. (I tried to find something similar answered previously, but nothing seemed to work for me.)
I have attached a small example spreadsheet below, but our spreadsheets can be hundreds or thousands of rows in length.
I need a macro that will look for the "PO Box" addresses under the column headers named "ADDRESS2" and "ADDRESS3".
The PO Box addresses will need to be moved under the column header "ADDRESS1" within the same row.
It will need to overwrite the text that is already under "ADDRESS1" and delete the text from the "ADDRESS2" and "ADDRESS3" columns - UNLESS the text in 'ADDRESS2" is a PO Box AND "ADDRESS1" begins with "c/o".
If the data in "ADDRESS2" or "ADDRESS3" is anything other than a PO Box it will remain the same. As will "ADDRESS 1".
Basically if there is a PO Box it needs to be in the column named "ADDRESS1" and overwrite anything else that was there. The exception will be for PO Boxes that are in c/o someone else, the PO Box will then need to be listed in the column directly after the column that has c/o.
If the c/o exception will be too difficult the code could just highlight those scenarios and we could fix them manually. We usually do not have a lot of them, but enough that we need to be mindful of them.
The different scenarios are listed in my sample spreadsheet.Also, the code will have to use the column header names in row 1 because those headers are not always in the same column.
I have two different Excel reports and the data needs to be copied from each column on one spreadsheet and pasted to the bottom of the equivalent column on the other spreadsheet.
So, is it possible to get a macro that will copy the data from one column then paste it to the next free cell in the column on the other spreadsheet.
If I could get some code to do one column then this should be enough to get me started and I could apply this to the other columns I need to copy.
Am trying to put comments on column G based on information on column A. Column A contains a grade eg CDEF picked up from another sheet using vlookup. This grade is suppossed to be the same, but I have cases where I add a different grade say GHIJ to fill up my 99 required grades.Column G is for comments such as "Transfered" (which at the moment am entering manually)How can I use a formular so that each time I transfer from another grade other that the one intended it returns a comment "tranfered" on column G? Is it also possible to indicate the cell from which vlookup picked that grade on the same comment column G.
I am trying to move a column of numbers based on the information in another column. I've been looking for about a week and find macros that are close but not quite.
In one column it reads Mobile, Home, or is blank. If the number is a Mobile (column R), the area code (column P) needs to move to column S and the phone (column Q) needs to move to column T and the primary phone (column R) needs to move to column U. Home and blank cells remain as they are.
area (P) phone (Q) primary phone (R) col S col T col U
I have attached a sample spreadsheet – what I want to do is insert a column before the current column A and move the current column D in to it and auto fill for every non blank cell in column B. Also, there are different values in column D such as “B03” ,”B41” etc – so for example, it should auto fill B03 until it comes across either a blank cell in column B or it comes across a “B41” and then it should do the same until it comes across a “B42” or a blank cell again. This needs to continue till the end of the report.
I’m looking for a formula which returns me the information from a row (for example in C2,D2,E2 etc.) to a column. So the information in B3=C2, B4=D2, B5=E2 etc.
I have column A full of test numbers, and column D is revisions the tests show up in (4 different versions). I would bring this spreadsheet down from 1800 rows to around 500 rows by making the info on D appear on one line in columns E,F,G,H, rather than four rows.
If column F, G, H says PAP then I want it to return information from column A, B, C, D, E respectively into another worksheet. I have attached a sample
I am trying to use a nested IF to enter info into col A. It is based on 4 pieces of info, I can get the first 3 to work but am struggling with the last part. The problem is that I am looking at the same cell for the first 3 parts but the last part is looking at another cell reference. A nested IF may not be the way to go. An example of the spreadsheet is as follows:
A B C D AB 1 12/1/10 Comp 1 Surveyer 1 18/1/10 Omit 11/1/10 Comp 2 Surveryer 1 Omit 0 10/1/10 Comp 1 Surveyer 2 Comp 3 Surveyer 1
The formula I am currently using in column A is: =IF(AB3="Omit","Omit",IF(AB3,1,"0")) This works for the first 3 pieces of information but however does put a 0 in col A if there is no date in col AB, but this what I expect as it's what I've asked for. I am missing the last piece of information.
But what I want to put in column A is: If there is a date in column AB - enter 1 If there is the word 'Omit' in col AB - enter Omit If there is no date or the word Omit in col AB - enter 0 and finally If there is no date in col B - leave blank (if there is no date in col B, col AB will always be blank)
I am having trouble getting my search information to show under the column headings in the listbox. My search reference is column E and I want to show the information for column F, I and A of the same row as the search match. Here is my code and a copy of the file I am using.
I have a set of training information in the rows, with dates under it which maps back to names of employee in the left hand side. How do I convert that to Name of Employee Training attended dates expiry date.
I need help with a formula so that I can create a single chart or (more likely) multiple charts for each of the choices in column C.
Attached is a sample of my spreadsheet. I want to be able to break out each of the "Br#"(A) associated with the "BUM"(C) and graph each of the choices in column D (Run Time).
I am sure I can create the chart I need once I get the formula created to pull the data I am trying to combine. I hope that I have explained this well enough.
I am basically trying to find the first non-empty cell in a range, but I want the macro to look down columns first. In other words, I want it to look down column A, then column B, and so on. Right now I believe it is searching by rows.
With Columns("A1:D15") .Find(what:="*", after:=.Cells(1, 1), LookIn:=xlValues).Activate End With
Previous question regarding dynamic ranges within a table to create a dynamic chart.
I've now come across another issue regarding the same table but creating a new graph to display a new graph. This time, I need the graph to only include labels with data in them.
The data is based on months including achieved targets and forecasted targets. I need to show a graph for the achieved targets to date and exclude any future months from the graph. e.g. For this month, I would only want to show January to July values and not include August to December.
How easy is this to do? I don't know how to use the OFFSET function but think that this might be a possible solution.
I have a column 'AE' that contains the html code for ecommerce item descriptions. While importing/exporting back and forth with another program and my spreadsheet, the following was added all throughout the descriptions.
%0d%0a
In some places, it may be three or four times consecutively
%0d%0a%0d%0a%0d%0a%0d%0a
Is there a macro script I could run to simply remove this any time it occurs in this column? It is just showing up as text and I am sure in another program it was representing something other than text, probably a space or hard return. Regardless, I don't need it.