I'm doing a 301 redirect map for an art supply shop so I need to match URLs from the old site to the new one. The trouble is there are over 27,000 URLs and the URLs on the old site are quite different to the ones on the new site. The old URLs need to be matched to their equivalent on the new site, however some pages aren't on the new site in which case the old URL needs to be redirected to an equivalent product or category page.

I HAVE TWO EXCEL FILES

FIRST IS 4 MD MARCH AND OTHER FILE IS NEW MICROSOFT EXCEL SPREADSHEET

IN NEW MICROSOFT EXCEWL FILE U CAN SEE IN A ROW AS ITEM CODE FROM 1 TO 140 IN SOME IT WILL GOES NUMERICALLY IN SOME IT GOES RANDOMLY SO I HAVE USED IF FORMULA IN 4 MD MARCH TO GET ITS SALE VALUE FROM NEW MICROSOFT SHEET BUT PROBLEM IS IF ITEM CODE CHANGES THAN IN MY 4 MD MARCH FILE IT SHOWS FALSE SO HOW TO CALCULATE IT IN WHICH FORMAULA SO IF I PASTE ANY ITEM CODE IT SHOULD GO TO ITS EXACT PLACE

We have a business where we scan business cards for our clients. We give our clients an excel spreadsheet as the finished product. We want to create a way for our clients to be able to find a contact easily. We have looked at the forms option, but the client would have to set a few things up (like putting the forms button on the tool bar, etc.). Our Clients just want to use the info we have provided them. We just want to make it easy for them to find the data. I would assume that some of the Excel experts out there may have already written an application to do this simple task.

Please look at my workbook. It's a very simple one.
Sometimes it works sometimes it gives me Error 1004 Invalid Parameter.
I haven't changed anything in the code. Do you know why?

If I click on cell B3 and run the macro it seems to work, if i delete sheet("chartgroupingsforchart") and rerun the macro it doesn't work any more

Hello,

sorry if this has been posted elsewhere, but I've tried all suggestions previously provided here and it didn't work for me. I'm completely new to VBA and would be VERY thankful for your help. Here's my problem:

I'm trying to create a table that adjusts dynamically to how many cells in a row have text in them. In other words, when a cell is left blank, the entire row should not appear in the table.

I've tried the following code:

Sub test()

Dim i As Integer
Dim nrrows As Integer
Dim sheetname As String
Dim column As Integer
Dim startrow As Integer

Hi guys!

I'm new on the ExcelExperts and also new on VBA Excel programming, but I'm trying to do something pretty difficult to me so I came ask if someone have any idea of how I could do that.

Basically I need that a macro runs automatically when a specific cell is filled or considering the entire plan, it should run when the program stop sending information to the plan. For that I already made a researched and found a way using auto_open() using the following code:

Sub auto_open()

' Run the macro DidCellsChange any time a entry is made in a
' cell in Sheet1.

What can I do to make the code work?
Many thanks

Sub CreateGraph2()

Dim rowNumber As Integer, r(4) As Range

Sheets("Groups For Charting").Range("A1").Select
ActiveCell.FormulaR1C1 = "=COUNT(R4C2:R683C2)"
rowNumber = Sheets("Groups For Charting").Range("A1")

Set r(0) = Sheets("Groups For Charting").Range(Cells(4, 2), Cells(rowNumber, 2))
Set r(1) = Sheets("Groups For Charting").Range(Cells(4, 3), Cells(rowNumber, 3))
Set r(2) = Sheets("Groups For Charting").Range(Cells(4, 4), Cells(rowNumber, 4))

Hi

I'm using excel 2010 when i use copy as picture, it gives me always a yellow background. Also when i do copy and then choose past picture it gives a yellow background.

Any idees to get rid of the yellow background?

I do not find anything in the options.

Hi All, this is my first time posting so I will try to be as detailed as possible.

I am very new to VBA and am trying to make a macro that can do the following for 50+ identical workbooks with different cell values and combine data in their respective columns:

1. fill a cell with filename
2. Copy A1:B2
3. Copy J6:J95, M6:AI95

I have had luck with youtube demonstrations for copying columns, however I am stuck trying to copy all these at once :(

The end result I am hoping for is something like this:

A1(File name)
A2:B3 (Copy of A1:B2)
C1:Z89 (J6:J95,M6:AI95)

Dear,

Can we swap or exchange data within two cells wchich are together or seperate. For example; I want to send data in C1 to E5 and E5 data to C1. And can we do this for number of sells (blocks).
Hope your usual help
Tks/ulsk

I keep getting a byref type mismatch error whenever I try to run this program. It is supposed to find the zeros of the equation f(x)=3x^2+ln(x) through the bisection method. I have to find the zeros, and number of iterations it takes to get it. This is what I have so far and I'd appreciate it if someone could point out my mistakes.

Option Explicit
Function bisection_equation(n As Double) As Double
bisection_equation = 3 * (n ^ 2) + Log(n)
End Function
Sub bisection()
Dim x_low, x_high, x_guess, diff As Double
Dim i As Integer

I would like help with a conditional formatting.

I would like every value in a column that is true to then look across at a different column and add the total

2 Europe TRUE FALSE FALSE FALSE FALSE
2 Vietnam TRUE FALSE FALSE TRUE FALSE
2 Europe TRUE FALSE FALSE TRUE FALSE
2 Europe FALSE FALSE FALSE TRUE TRUE
1 London TRUE FALSE FALSE FALSE FALSE
2 Vancouv TRUE FALSE FALSE FALSE TRUE
1 Munich TRUE FALSE FALSE FALSE FALSE
4 Europe TRUE FALSE FALSE TRUE FALSE
1 Central TRUE FALSE FALSE FALSE FALSE

Could someone decode the attached macro foe me?

I work for a school district and need some help with a new requirement we were just given for scoring some student scores.

The spreadsheet (see link below) was created to keep track of students test scores for various things. This spreadsheet will contain students information and a student will be shown more than once in the spreadsheet. The Student ID is what we will key off of to find the multiple instances of the student.

How to display values of 2 variables which range from 4 to 15 in 1 message window using MsgBox?

Hi
I’m a newbie here after being promoted to an office role after being a service Engineer,
What I wish to achieve is a self-populating cell as below
Sun 2 Mar to Sat 8 Mar 2014
The next cell would read
Sun 9 Mar to Sat 15 Mar 2014
If anyone can help I be so great full
How do I input self-learning in to excel
Many thanks to all that view & help

I have here a excel project that veiw in full screen and shows worksheet in slideshow view. the problem i am having is that in slideshow view i cannot update data (via macro;web query), however this will work in just fullscreen view just not when slideshow is running. If someone could please review my code and see where i might have messed up (also to open the slideshow menu press the little cloud up in the right corner or just run the macr as i still have some bugs to wotk out)
thanks in advacne

i have grades for students i wanna arrange them in a certain order in order to put them after in certificate for each one
i have 2 worksheets the first one have all the grades and the other sheet will read from the previous sheet in a certain order like the following example
first student

C2 = sheet!C2
C3=sheet!E2
C3=sheet!G2
and so on till
C10=sheet!s2

then the second student will come in C11 and should repeat the first sequence like the following

C11=sheet!C3
C12=sheet!E3
and so on

how can i fill this sequence can u help me

I can assign a Macro to a control Listbox, how can I assign a Macro to each item of the control listbox?
Thanks

I have an array with a list of friends in a column and family and relatives along the top row. Each entry is the relative amount of agitation caused to my family by the friends who are visiting. If certain friends are invited over, I wanted to combine the agitation factor to each family member in a new array. To explain, here is the array. (x=ok, xx=mild, xx-strong dislike, no entry=neutral)

A B C D E
1 Mom Dad Sister Brother
2 tom x xx xxx

Hi All,

So a bit of vba help please and thanks! I'm looking for a macro that will copy and paste the values in a range of cell from the sheets of one workbook to the sheets of another master workbook. I want a macro that will let me select which second workbook to copy from, and then copy the information from the sheets in the second workbook that are named the same as the sheets in the master workbook.

For example:
workbooks: MasterWorkbook (MWB), DataWorkbook1 (DWB1), DataWorkbook2 (DWB2)

I have created one excel file which is of size around 60 MB. I have found that this size is only due to worksheets "Item Formal Check", "Old VS New - All MKT Check", "Old VS New - All FCT Check", "Old vs New - All Prod Check VOL", "Old vs New - All Prod Check VAL" ,"Trend Brand" and "Trend Products".

In all the worksheets lots of links and formulas are applied.
Due to large size I could not able to send into mail which is of limit of 4 to 5 MB.

I wrote the following code in vba, I would like for every selection in listbox to call a macro.
It doesn't work How can i correct it?
I use control form listbox

First Part: Working
Sub Macro8()
Dim x As Integer
' Macro8 Macro
'
For x = 1 To 20
ActiveSheet.ListBoxes("List Box 23").AddItem x
Next x

End Sub

Second Part: Not working
Sub Macro4()

If Selection.ActiveSheet.Listboxes("List Box 23").List = 1 Then
Call Macro1
End If
GoTo 10

If Selection.ActiveSheet.Listboxes("List Box 23").List = 2 Then
Call Macro2
End If
GoTo 10

10 End Sub

Hello

I need ideally a formula that can do the following;

Example of the cell A3 tag 1FINDandREPLACE

Step 1: Look within a specified cell (i.e cell A3) and copy the tag in that cell.
Step 2: Search within cell B2 (B2 contains various text that includes the tags).
The tag in cell B2 is then to be replaced with the content from cell B3.

Step 3: Repeat steps 1 & 2 for tags A3 to A9 and MASTER HTML FILE B1 to L1 and more

This is a simple idea, but unfortunately I have not been able to find the code already in the forums that can do this task?

Hi Experts,

Could you please suggest me where I am wrong regarding the below recorded vba code. the below code is to sort data by black colour at bottom. By doing it manually its works perfectly , however by recording not getting the desired results. Please help.

Sub Macro2()
'
' Macro2 Macro
'

'
'Columns("A:E").Select
ActiveWorkbook.Worksheets("Sheet1").Sort.SortFields.Clear
ActiveWorkbook.Worksheets("Sheet1").Sort.SortFields.Add(Range("A2:A22"), _
xlSortOnFontColor, xlDescending, , xlSortNormal).SortOnValue.Color = RGB(0, 0, 0)

Hello,

I have a file with many values, distributed across multiple columns.

From sheet1 i want to find and move all the duplicate values in the sheet 2

and I need a macro,a code macro to work at the level of the sheets, Sheet1-Sheet2

I want to move cut/paste all values duplicates 2 times 3 times or how many times is found
from sheet1, in sheet2 the results to be made in columns A and B

in sheet 1 to remain single value, only the values themselves which didn't pair
I mean if a value is 2 times
to move the original value
but and double found

Thank you

Hi,

I am piecing together a Profit/Loss Spreadsheet which is automatically updated by the Bloomberg Add-In. I input the price at which I enter a position and then input the price at which I would like to exit the position to take profit.

I want to be able to say something like "if the live price(updated automatically from bloomberg)> price at which I like to take profit, input the difference at that moment into another cell.

Any help with this would be greatly appreciated!

I wish to have the following conditional formatting, but I am not able to correctly put the formula. Can anyone help me with this?

Cell F39:
Color code "Green" if F39 contains text "N/A" or "Yes"
Color code "Amber" if F39 contains text "No" & F38>=1<=50000
Color code "Red" if F39 contains text "No" & F38>50000

Cell F38:
Color code "Green" if F39 contains text "N/A" or "Yes"
Color code "Amber" if F39 contains text "No" & F38>=1<=50000
Color code "Red" if F39 contains text "No" & F38>50000

Cell F37:
Color code "Green" if F39 contains text "N/A" or "Yes"

Hi,
I have used the formula below in my excel 2007 spreadsheet but unfortunately it is not working. Either I have misunderstood how this should work or I have a missing or misplaced bracket or comma.

Hi,

The excel file attached has a sheet named "Average Rank". Each of the items listed in the "App" column falls under a category in the sheet "Category". Now I have the data for each of the month (they are basically rank averages) for each of the items in column A of the sheet "Average Rank".

I have given a conditional formatting to the table (red to light yellow color) based on the decreasing order of ranks (from 0 to 20)

here's what i want: