In order to transfer a column of data into a Crystal Report I need to add a comma (,) to the end of each cell in a range. These cells are all comprised of numeric characters, representing player card numbers.
I was wondering if someone could point me in the right direction. Firstly, I am using Excel 2007. What I am trying to do is add to the bottom of a list/column of values. The value I want to add is a changing value which I have set to change once every minute.
For example, in cell A1 I have the value '2000' This value '2000' is placed into cell B1 Once the minute has elapsed, the value changes (by web capturing). This value could be anything. But I want this new value to be placed below the B1 cell, into B2.
Then, another minute passes, the cell A1 value could be different again and I want this new A1 cell value to be placed below the B2 entry, into B3.
I have a download of public records from a local County Auditor, regarding property ownership. However, the data, as it is provided is incomplete. I have obtained, from another source, much of the missing data and would like to append the original data.
I don't know if this is even possible, but in 'Googling' it, I am optimistic.
I have attached an Excel 2007 spreadsheet with a sample of the County data on Sheet1 and the data that I would like to append on Sheet2.
Sheet1 lists the parcel number (A), and information regarding the last five recorded sales. B: Sale Date C: Deed Type D: Buyer Name E: Recording Number F: Sales Price G: Multiple Parcels ("Y") H: Notes I: Loan Information.
Then the B-I information is repeated four times (J-Q, R-Y, Z-AG, and AH-AO or also defined as columns 10-17, 18-25, 26-33 and 34-41) for a total of the last five sales.
Sheet2 is a listing of sales with similar information. A: Sale Date B: Parcel Number C: Buyer Name D: Sales Price E: Recording Number F: Deed Type G: Multiple Parcels ("Y") H: Notes I: Loan Information
What I hope to do is this:
If the 'Recording Number' (E) on Sheet2 matches the 'Recording Number' (E) on Sheet1, then replace the eight columns on Sheet1 with the data found on Sheet2 (pertaining to a specific sale number).
If the 'Recording Number' (E) on Sheet2 does not match any 'Recording Numbers' (E) on Sheet1, replicate the (unmatched) data (from Sheet2) on Sheet3.
My hope is that this will give me updated, and more complete, data on Sheet1 and also show me all the data that did not match on Sheet3 for me to use later.
I have included headers on both sheets in hope of making things clearer to the reader.
I am having problems fixing my function code so that instead of appending myDate with (1) (2) (3) if 3 occurences of the date already exist it just appends it with (3). I know it has to be something simple but I know I am doing something wrong. Thanks for helping a beginner out.
Sub ImportSheets() Dim fName As String Dim WB As Workbook Dim myDate As Date fName = Dir("N:ENGBRANDON*.csv") Do While fName "" Workbooks.Open fName Set WB = ActiveWorkbook 'Copy first sheet to this workbook With ThisWorkbook
how to search for this so I'm just gonna ask. See sheet below I faked the resulting formula I need) for reference.
We have an engineering database that spits out data. One of the things it spits out is a list of equipment tags along with its associate electrical drivers (I.e. motors) and details for each. I need to do some extra playing around with the official equipment list that we have to produce.
In a nutshell, if an equipment tag only shows FIXED in any of it's drivers, I want the formula to show nothing (blank). However, if the word VARIABLE appears in any of that tag's drivers, I want it to show VARIABLE. I know there's a formula involving IFs and whatnot, I just can't figure it out.
I'm trying to create a spreadsheet that will automate our job bidding process. We have alot of standardized phrases we use and I thought it would be nice to just click on the phrases that are pertinent to the user's current bid. How do I get the user's current selection (from a form, not a cell) to append itself to the "current" end of the bid (a worksheet)? In other words, previously entered information by the user (name, address, type of bid, etc.) is already updated on the new worksheet created by the new bid, but how do I get the user's current selections to find the end of what is already there, and add itself to the bid at that point?
I have a workbook named as "DCR_Summary". In the sheet "FX", I want to get the sum of a specific column from two different workbooks named as "WNCR REPORT" and "DCCR-REPORT". The name of the column is "FXCOLL". The summation should start in row 7 all the way down where data is available. The good thing is that, my sum range will always starts at row 7 in both files but the bad thing is that the position of column "FXCOLL" is changing every day. The expected result is shown in the attached "DCR_Summary". It should pick at the same time the Sheet names where the summation came from. Sheet names is also changing and sometimes the FXCOLL is nil, hence, 0 value can be returned.
I've a workbook with two sheets 1)'weekly' and 2)'summary.'
Weekly is divided into products (up to a maximum of 8) with a fixed number of columns (4) directly below but a varying number of rows beneath as follows:
Product A (main header) Issue|Serial Number|Analysis|Comments data|data|data|data data|data|data|data data|data|data|data data|data|data|data
--couple of blank rows--
Product B Issue|Serial Number|Analysis|Comments data|data|data|data data|data|data|data data|data|data|data
--couple of blank rows--
Product C Issue|Serial Number|Analysis|Comments data|data|data|data data|data|data|data data|data|data|data data|data|data|data data|data|data|data data|data|data|data
This weekly data must be appended into each product's respective grouping within the 'Summary' tab. With the following small additions: 2 additional columns filled with the model and current week must be inserted beforehand:
I have a folder containing 1000's of files. All the files end in .txt (for example test.txt) but are actually excel files. When I go to open the files with excel I get the following warning:
The file you are trying to open is in a different format than specified by the file's extension. Verify that the file is not corrupt and from a trusted source before opening the file. Do you want to continue?
I click "yes" and it opens fine as an excel file.
I want to merge all these files one after another into one file.
appending excel sheet number in a formula. Here is the example.
In an excel book, I have sheets 1 to 50. In each sheet i have a standard format to enter the details. And in one sheet I want to keep some summary with required cells. I made a table by applying formula, for example in cell A1 i kept formula ='9'!$D$9. In this '9' refers sheet9. In the similar way i want to capture the data from all sheets.
I'm creating 10 'categories' for Column "C" that I plan on using drop-downs to select from. Column "H" has a value tied to "C". What I want to do, is have Excel SUM all of the values in Column "H" where the Category in "C" is a specific text value (e.g. say a category is "hardware", I want a cell with a formula that sums all of the values in "H" where "C" is "hardware".)
I'm working on a project for use by our sales teams to for them to easily find out which campaigns are currently being offered in their regions. The data looks like this:
IN, OH, MI, IL, NE, AZ
IN, OH, MI, IL, NE, AZ
IL, WI, MN
This is going to be embedded internally and needs to be as simple to use as possible. I would like for column A to be filterable by state, either with a drop down menu or a selector. My problem is that many states could be in one cell, or individually in a different cell, and the default autofilters recognize these as two different values. I would like the sales rep to be able to filter "IN" for example and get 5 results. One solution that I am aware of is for me to duplicate each campaign on a different row and list one state per row for that campaign. The issue with that is that this is going to be updated frequently and that is a tedious manual process. I am also aware that you can use a text filter for "contains" specific words, but even that is more intricate than what I am aiming for.
i have excel sheet with name labels.i want count how many times user repated along with his branch code. acctully am done this using this formula, but not getting what am exepected.
Formula in B1 is ="JSK-SW-1"&(countif($A$2:$A2,$A2)) output is value is incremented, but i want text also be change. A B Name Count Sateesh JSK-SW-1 Rajesh Raj- SE-1 Sateesh JSK-SW-2 Rajesh Raj-SE-2 Anil JAK-DE-1
A B Apples 1 Apples 1 Bananas 1 Carrots 0 Carrots 0 Donut 1 Donut 1 Donut 1 Donut 1 Egg 1 Fish 0
I would like a to create a function in one cell that counts the unique text values in column A, but only when there is a corresponding 1 in column B. So the answer in the above example would be 4 (Apples, Bananas, Donut, Egg).
I have a bunch of rows that overlap other cells after using the format painter. My workaround has been to drag the row down to reveal the cell values. What's a better way to highlight many rows and do this in one shot? Adjusting each row to reveal text isn't efficient. I would like to not use macros either to solve this problem.
I am trying to transfer data from some appointment based software into a spreadsheet . the data comes out as one row For example ,the following is the contents of cell A1: 06/06/2014 09:00 AM - 09:30 AM Patient: John Smith
What I would like to do is extract one column with the date ,one column with the patient forename and one with the patient surname.
I have tried various combinations of =RIGHT(A1,LEN(A1)-FIND(".",A1)) etc etc but cannot extract the data I need
I am trying to create a formula to display a string of text that refers to multiple cells. for example, =If(A1=0,"insert text here" &B1 "insert more text here" &B2 "insert even more text here" &B3, "insert text here" &C1 "Insert text here"). It works fine for one cell value, like ="Total: " &A1
I have the below macro which is failing to insert text into A1 of the Header Sheet, followed by the values in the designated cells that are from Sheet1. I would also like to have the values in cells J2 and K2 enclosed in single quotes.
Sub Header() Worksheets("Header").Activate ActiveSheet.Cells(1, 1).Select ActiveCell.Value = "create or replace" & " '" & Sheet1.Range("J2").Cell.Value & "' " & " '" Sheet1.Range("K2").Cell.Value & "' " End Sub
how do I get it into the nicely formatted version most of you are using? The Mr Excel HTML add-in?