I have the following code. It takes data from one sheet and inputs into another. When I enter a Customer ID in cell G12, starting on Row 18 and proceeding down, jobs are listed. When the macro posts into the history sheet, it posts the jobs in rows. I wish for each time I run the macro, the info is all in the same row whether theres two jobs or 20 for that customer ID. Right now it is posting like this (two jobs listed):
I have a workbook that I want to copy two separate ranges from and then post to two different sheets. Range one on the active sheet from A4:K(no of rows will vary) to sheet Savoury Year, and range two A64:K(no of rows will vary) to Site Services Year. When pasting I want to paste it to the next empty row down.
Copy of workbook attached : Weekly Accounts.xls‎
I have been able to produce a column that gives me key date information. I might have many empty cells in that column before it hits another date. I need to get this data over to another sheet and place it in a row.
I am trying to get it to look like this:
B2(value), C2(value),D2(blank),E2(Value),F2(Value),G2(blank) etc depending on how many more elements are found in the sheet.
I am able to find topics that allow me to copy a range of data but not one that will allow me to copy a range then skip a cell.
I have a data sheet where the user puts the date the activity takes place and the place,reason, and staff. What I am trying to do is once the user puts the data on the data sheet, the data is place on the calender sheet for that month and date.
I am in a process of creating a excel based productivity for my team. This workbook has 2 worksheet, one is QA productivity tracker which is accessible to all, after the information is filled i want to store it daywise in a master tracker (next worksheet).
I have created a macro which copies the information to master sheet, but the challenge i am facing is that at every execution, macro should paste the data in next row.
I have finally come up with a macro and would like to install it to around 10 people's "Personal Workbook" in my department. Let me explain a bit further...
We use web-based software which has an "Export to Excel" option which we all use. The resulting data populates into a spreadsheet automatically.
I would like the user to be able to click on Tools/Macro/Run Macro and then run that particular macro. I assume that this macro should be in the "Personal Workbook" so that the macro will be visible no matter what worksheet they may have open?
Can this be done automatically/with a macro or must this be manually done?
In my file i can insert text to a certain cell and column but this is for one entry only. I am wishing for a run that for every entry, there is a new row.
Here's my file sample project.xlsm
You can see there the user form for a post entry. The user should fill-in code and description and if he hit save, the code and the description should be recorded on list provided the sheet.
I'm not that clued up on VBA or macros but I do have a few i regularly use, I’ve found a thread related to my problem but cant make much sense of it.
Basically i want to post the 3 cell values (C5,C7,C9) into row B20,C20 and D20 respectively. However I want these values to form a list staring with row 20 and working down onto the next available/empty row.
I have a list of UK Post Codes that I wish to filter but because of the format I'm getting problems.
The reason is that I'm only interested in the first part of the post code.
Example: Using IP7 6NH and IP32 8LR. If I tried to filter those using greater than then Excel would treat IP7 6NH as larger then IP32 8LR because 7 is larger then 3.
The post codes are all imported from another piece of software and are always in the format of 3 or 4 chracters, then a space and then 3 more chracters. I wish to create another column which only has the first part in it. So I wish to crop IP7 6NH down to just IP7 and IP32 8LR down to just IP32.
Then I want to make a further column which looks at the value in the first new column and returns "In" or "Out" based on some conditions.
These are the conditions. If the cell begins with CO or NR or CB or CM or PE, regardless of the rest of the value, then "Out" should be returned. If the value is between IP1 and IP6 inclusive then "Yes" should be returned.
If the value equals IP7 then "No" should be returned
If the value is between IP8 and IP17 inclusive then "Yes should be returned.
If the value is between IP18 and IP29 then "No" should be returned.
If the value equals IP30 then "Yes" should be returned.
If the value is bewteen IP31 and IP33 inclusive then "No should be returned"
I'm think that it's quite complex and maybe the way to go would be to have two other columns, one containing the "In" values and the other containing the "Out" values, that a formula can refer to when making it's yes or no choice but I don't know how to do that.
I may have missed it, but I can not seem to find where I can customize Excel to add a "paste formula" button. (I have a fair amount of copying to do where I do not want the formats being changed at the same time.)
Is there a way with a formula to have a result of one cell pasted in a different cell? ie. C1's formula =if(and(isnumber(a1),isnumber(b1)),b1-a1,if(and(isnumber(a1),isblank(b1)), b1 = d1,"")
A B C D 12/18/06 formula above =today()
if b1 isbalnk it will copy the value of d1 to b1. I dont know if this can be done i have looked at offset and a few others but it doesnt look like this can be done but want to see if i have over looked domething
If the user clicks on a cell within a specified range ("DataEntryWindow") which contains formulas, I want the formula RESULT to be copied on to the formula bar for that cell (not in to a cell) - the user can then press enter to replace the formula with the result, or escape to cancel
- you can do this manually by copying the cell as values to another cell, then copying that value to the clipboard letter by letter, then clicking on the original, clicking F2, selecting all the formula text, then pasting the clipboard!
Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(Target, Range("DataEntryWindow")) Is Nothing Then curval = Target.Value Application.SendKeys "{F2}" 'Application.SendKeys "???" ' some keyboard combination to go left, left, left Application.SendKeys curval End If End Sub
Needless to say, it doesn't work. sendkeys seems to do nothing at all. is there an object in worksheet for the formula bar that i can paste to?
I am creating a 'add supplier' userform, in which i open the userform, type in the new suppliers information, then press submit.
The problem is that the data i enter deletes the data that i previously entered into row 26 instead of posting the data into a new row (I wish it to be 27, then 28, etc)
is there a function that will return the specific content of the cell. like for example, i have a cell that contains the word DOG(a1), and on the other one is a sentence like THEDOGBARK(b1)...the function must find the word dog and must put it in another cell(c1).
I believe it was yesterday this board had a post how to lock and protect cells with data and leave them unlocked and unprotected if they're blank, but I can't find it. Does anyone know where it was?
I have an excel calculator that I use daily (mostly written in VBA). I change some of the values to get a new result. Is it possible to post the values of the results in a column so that I can see what the old values are? For security reasons I cannot disclose the calculator but I guess I can post an example of how I would like it to work.
I need to write a pattern for a postcode. I have the below (very basic I know and loses lots of combinations but i'll deal with that later) but no matter what I enter in the box I get mt error message saying the input in incorrect....
(1)I am using a userform (this contains a listbox) to update cell A1 which in turn updates a cell B1.
(2)I then run the next userform on cell A2 which should update its listbox from column B (which has just been updated previously).
My problem is that following step (1) the spreadsheet gets updated but when I processed to step (2) the listbox within the userform is not updated to show the information now in column B.
Finally, if I run the user form again (same as step (2)) the listbox has been updated .
I'm setting up a spreadsheet to calculate redundancies. Part of this is calculating a person's number of days of service. The trick is that I need to calculate if any service is before 01/07/1983 and note that separately to any service after 01/07/1983.
For example, if someone commenced work on 07/03/1980 and finished 15/08/2004, then I need the result to be:
Pre 01/07/1983 - 1211 days Post 01/07/1983 - 7717 days
I've used IF formula, but just can't get them to work properly.
I don't believe my earlier post was a duplicat thread. I posted the original thread, then posted a LINK to the original thread. I didn't even ask the question in the link, so there was no way someone would have wasted time answering the question from there. I didn't think I was breaching protocal. Anyway, since both instances of the thread were closed, here is the re-post.
I've recently been trying to learn a little about pivot tables. In the example attached, I have 2 worksheets. One holds raw data collected from suppliers, the other holds a default pivot table created from that data.
I am trying to attach an Excel file to a post. I found the following in FAQ: "To attach a file to a new post, simply click the [Browse] button at the bottom of the post composition page, and locate the file that you want to attach from your local hard drive" But I cannot find the [Browse] button. I should have said "to attach a file" not "to attach a post" in the header.
I am not sure if this is possible but I am trying to extract information from a spreadsheet, the problem is that i need only the postcode but this is in a line with the rest of the address as follows:
123 street, town, AB1 2CD
Is this possible as i need to do this for 1000's so doing it individually will take forever!
i need someone that can think through this boolean logically. its been a long day at work and now I'm trying to walk through this boolean thing to make sure my data will post on the right pages.
I have an Excel Macro that will capture inputted customer/vehicle data from an input screen, at the end, based on questions answered, i need to place that data on 1 of 4 sheets in my excel document.
The questions are: Is this a Nationwide claim? (Y.N) (boolean = nw) Is the vehicle here? (Y/N) (boolean = vh)
So here's what i got if NW = true and VH = True then place data on "sheet1" if NW = true and VH = False then place data on "Sheet2" if NW = False and VH = true then place data on "sheet 3" if NW = false and VH = False then place data on "sheet4"
I can't think of how to write this IF statement for this to happen. can't get the logic going.
