I have a spreadsheet with 4 columns. Column 1 is a subject column. Column 2 lists a question, to which there are 4 possible responses which are located in Column 3. Column 3 has a Validation List for one of the 4 possible responses. Each response in Column 3 corresponds to a particular symbol,A,B,C or D in sequential order in the Validation List which I want to populate into Column 4 with a number value corresponding to the symbol. A= 0 points, B = 3 points, C= 6 points, D=10 points. How do I go about defining the lookup formula? I am using Windows 7. Thank you very kindly, Abdool

Hi everyone! I'm very new to most Excel functions and 1000% new to macros. Please keep this in mind when answering and make things as fool-proof as possible. ;)

Hi Team

In the attached spread sheet, We have a formula written for Transmitted Total.
This is formulated over the cells designated for Document Range. BEG and END.
Formula works good when the document range is single.
Formula dosn't hold good for multiple document ranges.

Please suggest us how to get this right for multiple document ranges too.

Thanks & Regards
KumarSreenivas A

Team..

Could any one plz respond to the mail written on 27th March with the subject line "Getting names for corresponding numbers"
I have provided the attachment which has been in follow-up

Regards
KumarSreenivas A

I have a spreadsheet that brings in multiple fields of data. I need to figure out a formula that will allow me to figure the amount of time worked on each customer by each representative. My event field is either Record opened, Record saved, Record closed, or start create record. The only two that matter for figuring time worked are record opened and record closed. Any idea on how I can figure the time worked on each customer and sort it by representative who did the work? I have attached a sample of what my spreadsheet looks like for reference. Thanks!! Any assistance would be appreciated!!

I am trying to complete a tracking spread sheet that needs to work within upper and lower bounds, such as If x is less than 100 and great then 50, then --, else --. The manuals that I have access to and the online help screens in excel haven't been any help.

Does anyone out there have a good handle on how to construct this kind of statement?

Thanks!

Mike

Hi,
I have a sheet with 600 plus pictures . I want to save 600 pics to png file separably. I used save as - webpage. All the picture were save as png file. However, we were duplicated. every picture is saved 2 files with 2 sizes.
I just want to ask you how to solve the problem
Thank you so much

Can anyone solve my vba Vlookup problem? I have a workbook with multiple worksheets and a user form that has two combo boxes, the first one fills from a named range and when a user selects a value from this combo box it fills another combo box. When a user selects a value from this combo box I need Vlookup to find the value in a named range and column 1 (left) is the same column that fills the combo box so the value that is being searched for has to be identical to the value found but the result always comes back empty?

Hi,

I am working on a new project in my current organisation. I need formula to calculate the exact payment date. Below is the details explanation.
Payment term Batch period
AP45 16th of the month-15th of the next month
AP55 16th of the month-15th of the next month
AP60 1st of the month-Last date of the same month
AP75 24th of a month-23rd of the next month

I'm trying to create a project for work. There are multiple workbooks in folders by name. We'll call this folder "R:\customers\invoices". Inside this folder are folders by name (Bob, John, Sarah, Etc.) This is a network drive by the way (in case that matters). The workbooks are located in the "Name" folders and are all the same template. Each workbook contains multiple sheets. Each workbook also contains a "Stats" worksheet that has only the summary information for each sheet in that particular workbook.

Hello,

I really have a problem on solving my VBA case. Hopefully the question can be solved by some masters of VBA.

Please see the attached spreadsheet for the your review.

I want to put sheet1 B29-D29 into sheet2 C3-E3
put sheet1 B33-D33 into sheet2 C3-E3
put sheet1 B37-D37 into sheet2 C4-E4
put sheet1 B41-D41 into sheet2 C5-E5
put sheet1 B45-D45 into sheet2 C6-E6 ... ...

When I put the following code on VBE Module1. it works well. However, it is a stupid way to compose such code:

Sub report()

Dear All

I have a problem with the excel sheets, I need your help
I have a hotel booking system I have to make it, we need to know each day what are the available rooms and the booked rooms, we want to create a booking board to have a snapshot of each day
We already have a master list for each booking and the details of the booking ,
We would like to have the last name of the person who has booked the room on the booking board only the last name, and the vacant room appear like vacant on each day ,
Note on master list we only have check in date and check out date

I want to add a line, lh margin to rh margin, immediately before the footer. Can someone help me, please, with the VBA code to do this. This is my VBA code to add a footer to a worksheet.
Sub AddFooter()
Dim Response As Integer
Application.ScreenUpdating = False
With ActiveSheet.PageSetup
.LeftFooter = "&8&F"
.CenterFooter = "&8&A"
Response = MsgBox("Do you want to maintain today's date as static ? ", vbYesNo _
+ vbQuestion)
If Response = vbYes Then
.RightFooter = "&8 " & Format(Now, "dd/mm/yy")
Else

I have a list of 100 values (prices in figures) in a single column. in next column i have their code names. i want that for each value, anyother value which is within 10 dollar range, less and more, their codes should show up in third column. E.G
2000 A D,B
2009 B A,G
2020 C G
1993 D A
4000 E
700 F
2015 G B,C

Hi,

Actually I have large amount of data of different customers.Some customers having a different code but they are related with one code.

So, I want to give them a new code on the basis of previous code and their name.

I am comparing their previous code first, then their first two names for giving them new code.

Hi there.
I have 3 different files, each one of them has macros and I use buttons in the Quick Access Tool Bar to run the macros.
When I have more than two of these files open and I run any of the macro that opens or closes one of the other files, the buttons in the QAT are duplicated. How can I avoid this behavior, is there any way to lock the QAT so it doesn’t get modified? It is important to mention that I have no problem with the macros... they run OK without any errors, but I don’t understand why the appearance of the QAT changes.

I have a problem witha spreadsheet in excel 2010 I have 3 columnsin sheet 1 and 1 column in sheet 2 the columnsare named in sheet 1 stock level , addition , total stock in sheet 2 the column is named picked, I want the figure in total stock columnto be the result of a formula eg = stock level + addition - picked and leaving the calculation in total stock column and this figure will only change when I add stock it always depletes from the picking figure can someone help
Thank you

Dear Experts,

Please help me for below case:

My ending stock balance (in quantity)of item a1 = 2,506 pcs.

During the year, we made a lot of purchases. If just have a look in one item a1, we can have the end balance is comprised of most recent purchase of 1,730 pcs in Nov 2014; 25 pcs in Oct 2014 and 751 pcs bought in Sep 2014.

Can you please help me to develop a formula to verify how many a1 remained from which month of purchase.

Attached file is more example for this case.

Much appreciate for your urgent help :(

Thanks so much

Dear Experts,

Please help me for below case:

My ending stock balance (in quantity)of item a1 = 2,506 pcs.

During the year, we made a lot of purchases. If just have a look in one item a1, we can have the end balance is comprised of most recent purchase of 1,730 pcs in Nov 2014; 25 pcs in Oct 2014 and 751 pcs bought in Sep 2014.

Can you please help me to develop a formula to verify how many a1 remained from which month of purchase.

Attached file is more example for this case.

Much appreciate for your urgent help :(

Thanks so much

Hi Friends,

I need an excel formula to add Year,month,day,hour,min which are placed in separate cell. The resultant date should be of format (dd/mm/yyyy HH:mm) and in a single cell.

Hello all,

I am new to Excel Macro and i was given the task with the following excel data

Date Brazil Turkey Italy Panama Lithuania
3/15/2014 110 47 192 0 2
3/16/2014 118 54 179 0 7
3/17/2014 72 22 96 0 1
3/18/2014 17 20 60 2 2
3/19/2014 19 17 57 0 1
3/20/2014 15 21 52 0 2

I am to create a Macro so the ending result for each Date like such.I have looked up various of ways to do it, but cant seem to find a way. Thank you very much

Date Country Downloads
3/15/2014 Brazil 110
3/15/2014 Turkey 47
3/15/2014 Italy 192
3/15/2014 Czech Republic 19
3/15/2014 Panama 0
3/15/2014 Lithuania 2

I need to be able to generate duplicate records based on a value in each record and assign a count value to each new record. The new records would appear in a different/existing sheet.

This is a very simplistic example; there would actually be much more data to duplicate:

In sheet1:
Product_Code Number_Of_Cases
123456-1 10
456789-0 5

would turn into:

In sheet2:
Product_Code Case_Number
123456-1 1
123456-1 2
123456-1 3
123456-1 4
123456-1 5
123456-1 6
123456-1 7
123456-1 8
123456-1 9

Hi,

I am new to excel vba and i am working on a request. I want to randomize a range of values stored in sheet 1 and insert them in another cell.

I am having values for sales consisting of product names and its price. there are 10 product names and its corresponding prices and is stored in cells E1:F10. I want to generate test data containing product names and its corresponding price. The generated data needs to be saved in the cells A1:B50

the product names needs to be randomized. This needs to be done in vba.

Any help is highly appreciable.

Regards,
KV

I need help writing VBA code to filter on the Activecell.

Currently it works except if the activecell is a Date!

I need the code to work regardless of whether the activecell is a date, amount, text, etc.

Basically the data being filtered is a database table that is in Excel.

Any help would be appreciated. Thank you.

I need help writing the VBA code to filter on my activecell.

My current code works except when the activecell is a date!

The data I want to filter is basically a database table, however, the column types vary. They may be an amount, a text, a date, etc.
The code appears to work except when it is a date.

The code needs to work regardless of the activecells data type.

Any help would be appreciated.

In the attached sheet I want formula in column C that will give the new order quantity with following logic;

If ("Product"="Product")of column A & I, ("Closing Stock" of particular product<"ROL" of particular product) & (Current "Date" (say date in B5 if formula is being applied in C5)-Any latest previous "New Order" Date>="Lead Time" of that product)

Means if it has given new order quantity once then it should not give it again within the lead time even though the closing stock is less than the ROL. For example if it gives 150 in C3 then 150 comes on or after 21.03.2014.

Hey guys and girls...

I have a big problem right now and hope I will get some help from experts!

I have to do a list with a hyperlink and I have no clue how to do it!

So here is the task!

A1 and B1 include the first and the last name. C1 includes a hyperlink of a manual you have to read! every cell is colored red but when you click on the hyperlink in cell C1 (no matter if you red it or not) all the rest of the cells included A1 and B1 turn green!
I have no idea how to program that! Please... I am desperate right now! How can I fix that??

Thanks for every help I can get

I am really struggling with this one. Any help would be appreciated. Some pre works leaves me with a list of people who have travelled. I would like to be able to create seperate workbooks that have the header as per the attached rows 1-6 and then the all the same "cost centre owners" (column ad) information within each seperate workbook. So the attached would produce 4 workbooks called "a johnson", "msmith", "K Klien", "Richard James" with 1, 5, 5,1, rows of data respectively. These workbooks would be saved sepeartely in a specified location.

Hello,

I want to select the dates(from column H) in which the value(in column I) is greater than zero and paste them in column K(Attachment). At the same time, I want to expand each day for 24 hours. That means, I want to repeat the date 24 times while pasting in column K. Kindly help me. I would prefer the formula as I hv to repeat the same for large number of sheets.

To make it more clear, I hv illustrated what I need in column N & O manually.

Many thanks