How do I find a file link? Usually, when opening a file with a link to another there is a "view link" button however I have files which open with "update" "don't update" and "help" buttons and I need to find & delete the link because I'm not aware of linkages in a couple of these files! Using the "trace dependants" does not reveal which file (or sheet within the same file for that matter). Any suggestions? Leon

]]>Hi,

I'm not sure if there's a way to do one but I can't find anything on Google.

I've an Excel sheet and when I view at it via Page Break Preview it has 10 pages in it. I want to make page 5 page 4 and vice versa. Is there a way to do this or do I manually have to copy paste and insert a page etc?

Thanks

]]>I'm not sure if there's a way to do one but I can't find anything on Google.

I've an Excel sheet and when I view at it via Page Break Preview it has 10 pages in it. I want to make page 5 page 4 and vice versa. Is there a way to do this or do I manually have to copy paste and insert a page etc?

Thanks

Problem 1. I have a column which contains

1. 5555/3/6/CBN

2. 988/2/3/CBN

3. 10889/2/11/ABCD

4. 0001/5/9/ABCD

5. 0400(C )R

6. AA-497(C)R

I want a formula which shows result like below:-

1. 3/6/CBN

2. 2/3/CBN

3. 2/11/ABCD

4. 5/9/ABCD

5. (C)R

6. (C)R

Please guys help me///////////

]]>1. 5555/3/6/CBN

2. 988/2/3/CBN

3. 10889/2/11/ABCD

4. 0001/5/9/ABCD

5. 0400(C )R

6. AA-497(C)R

I want a formula which shows result like below:-

1. 3/6/CBN

2. 2/3/CBN

3. 2/11/ABCD

4. 5/9/ABCD

5. (C)R

6. (C)R

Please guys help me///////////

Hi,

I need help in Excel. Hope someone help me to get answer on this.

I have huge data in excel where I need to search SAME entries.

e.g. For your example upload one sample data excel sheet.

In two workspace in single excel in that each workspace 2 columns and 20 rows there.

Both workspace B Column data added. Base on the first 3 digits search in full sheet and whichever is not common data in both workspace highlight with color.

For more information attached excel sheet.

Regards,

Avinashplace

I need help in Excel. Hope someone help me to get answer on this.

I have huge data in excel where I need to search SAME entries.

e.g. For your example upload one sample data excel sheet.

In two workspace in single excel in that each workspace 2 columns and 20 rows there.

Both workspace B Column data added. Base on the first 3 digits search in full sheet and whichever is not common data in both workspace highlight with color.

For more information attached excel sheet.

Regards,

Avinashplace

hi, I have the below formula, and I want to show empty if is at 0 Percent:

how can I do this? please help

]]>Code:

` =IF(LEN(CustomerName)=0,0,IFERROR(VLOOKUP(CustomerName,List!$B:$H,7,0),0))`

A simple question -

A yield table includes the calculation of yields each month.

Let's say in the first month of investment I write 0%

In the second - 1%

And in the third month - 1.5%

This table has a graph of a line.

The problem: In the third month the graph is 1.5% and the percentage was not agreed (the answer was 2.5%)

So how can this problem be solved.

Thanks in advance,

Sorry for the mistake if there is.

I do not know English well and uses Google Translator.

]]>A yield table includes the calculation of yields each month.

Let's say in the first month of investment I write 0%

In the second - 1%

And in the third month - 1.5%

This table has a graph of a line.

The problem: In the third month the graph is 1.5% and the percentage was not agreed (the answer was 2.5%)

So how can this problem be solved.

Thanks in advance,

Sorry for the mistake if there is.

I do not know English well and uses Google Translator.

I know that I can use ctrl + letter combination to trigger a hotkey , I get so many hotkey now and the ctrl + lettter can meet my requirement I need more how to make that?

]]>I press ctrl + g the new window **reference address bar** will show the address and then press ctrl c, to copy that. But when I press ctrl G now, I don't know why The reference address bar is empty so I can't copy that. So what should I do to copy the current cell address.

]]>I use ctrl + up before. It works fine when there is no empty cell in the column. But it doesn't work when there are some empty cells in the column. How to use shortcut to jump to the first cell of the current column ?

]]>I have two spreadsheets. I want to write a formula for the following: If the data in column A on Spreadsheet 1=Column A on spreadsheet 2, then include the data from Column B on spreadsheet in Column C on Spreadsheet 1.

Can someone help?

Thanks!

]]>Can someone help?

Thanks!

I have a basic income statement with from multiple companies as well as the total of all companies and want to put the % each contributes to each category below the actual number.

The formula is very simple, which is taking the value from each company and dividing it by the total, which I did for the first category. Now I'm trying to figure out how to do that with the rest of the values, which are blank cells in the area that has the values. If I do down the line and do it one by one it works, but would take forever.

To try to do in one fell swoop I tried copying the first row with the formula, then selected the range with the values and blank cells. Then I did "Go to special" and "blanks", which highlights all the blank cells. Now that I'm trying paste the formula there it won't work because it says the size doesn't match. I tried it with paste formula only and it still don't work.

Aside from using VBA is there a simple way to tell excel I want to take the formula with the row I'm copying and put it into the blank cells?

Please see the attached sample sheet.

The formula is very simple, which is taking the value from each company and dividing it by the total, which I did for the first category. Now I'm trying to figure out how to do that with the rest of the values, which are blank cells in the area that has the values. If I do down the line and do it one by one it works, but would take forever.

To try to do in one fell swoop I tried copying the first row with the formula, then selected the range with the values and blank cells. Then I did "Go to special" and "blanks", which highlights all the blank cells. Now that I'm trying paste the formula there it won't work because it says the size doesn't match. I tried it with paste formula only and it still don't work.

Aside from using VBA is there a simple way to tell excel I want to take the formula with the row I'm copying and put it into the blank cells?

Please see the attached sample sheet.

Hello,

I have an excel workbook with about 20 worksheets and need to save a range of sheets as individual PDFs files, each pdf's name the same as the respective worksheet name.

Appreciate some help with a VBA macro to do this.

I tried the following code but keep getting a Run time Error "5"; invalid procedure call or argument.

Option Explicit

Public Sub SaveWorkbookSheetsAsPDFs()

Dim WB As Workbook

Dim WS As Worksheet

Set WB = Workbooks.Open(Application.GetOpenFilename("Excel workbooks (*.xlsx), *.xlsx"))

For Each WS In WB.Worksheets

SaveSheetAsPDF WS

Next WS

WB.Close savechanges:=False

End Sub

Sub SaveSheetAsPDF(WS As Worksheet)

WS.ExportAsFixedFormat _

Type:=xlTypePDF, _

Filename:=WS.Parent.Path & Application.PathSeparator & WS.Name, _

Quality:=xlQualityStandard, _

IncludeDocProperties:=True, _

IgnorePrintAreas:=False, _

OpenAfterPublish:=False

End Sub

many thanks,

Sands

]]>I have an excel workbook with about 20 worksheets and need to save a range of sheets as individual PDFs files, each pdf's name the same as the respective worksheet name.

Appreciate some help with a VBA macro to do this.

I tried the following code but keep getting a Run time Error "5"; invalid procedure call or argument.

Option Explicit

Public Sub SaveWorkbookSheetsAsPDFs()

Dim WB As Workbook

Dim WS As Worksheet

Set WB = Workbooks.Open(Application.GetOpenFilename("Excel workbooks (*.xlsx), *.xlsx"))

For Each WS In WB.Worksheets

SaveSheetAsPDF WS

Next WS

WB.Close savechanges:=False

End Sub

Sub SaveSheetAsPDF(WS As Worksheet)

WS.ExportAsFixedFormat _

Type:=xlTypePDF, _

Filename:=WS.Parent.Path & Application.PathSeparator & WS.Name, _

Quality:=xlQualityStandard, _

IncludeDocProperties:=True, _

IgnorePrintAreas:=False, _

OpenAfterPublish:=False

End Sub

many thanks,

Sands

Hi guys,

This might be a very simple question. I hope someone can help me with this because I'm kind of new with Excel.

I have a database with patients who are numbered 1 to 1200 (1200 patients in total). These patients were given painmedication and scored their pain with a simple yes or no answer. Yes =1 no = 0.

The problem is that I have data of the same patient on t=0 en t=4. T=0 means before the patient was given the painmedication and t=4 is 4 months after the painmedication. I asked these patients to score their pain (with yes/no) on t=0 and t=4. Now I'm trying to calculate the difference. Let's say patient number 5 answered yes( =score 1) on t=0 and on t=4 answered no (=0). In the Excel database it looks like this:

Patientno Time Pain yes/no (yes=1, no=0)

1 t=0 1

1 t=4 1

2 t=0 1

2 t=4 0

etc.

Now I want to make a formula to calculate the difference in painscores. For example the difference in patient number 1 is 0 (on t=4 the score was 1 and the score on t=0 was also). For patient 2 the difference is minus 1 (0 on t=4 minus 1 on t=0). I'm kind of stuck here, It takes too much time to calculate this without a formula. Could anybody help me or point me in the right direction. It's very appreciated

Thanks for reading!

Michael

]]>This might be a very simple question. I hope someone can help me with this because I'm kind of new with Excel.

I have a database with patients who are numbered 1 to 1200 (1200 patients in total). These patients were given painmedication and scored their pain with a simple yes or no answer. Yes =1 no = 0.

The problem is that I have data of the same patient on t=0 en t=4. T=0 means before the patient was given the painmedication and t=4 is 4 months after the painmedication. I asked these patients to score their pain (with yes/no) on t=0 and t=4. Now I'm trying to calculate the difference. Let's say patient number 5 answered yes( =score 1) on t=0 and on t=4 answered no (=0). In the Excel database it looks like this:

Patientno Time Pain yes/no (yes=1, no=0)

1 t=0 1

1 t=4 1

2 t=0 1

2 t=4 0

etc.

Now I want to make a formula to calculate the difference in painscores. For example the difference in patient number 1 is 0 (on t=4 the score was 1 and the score on t=0 was also). For patient 2 the difference is minus 1 (0 on t=4 minus 1 on t=0). I'm kind of stuck here, It takes too much time to calculate this without a formula. Could anybody help me or point me in the right direction. It's very appreciated

Thanks for reading!

Michael

Good Night,

I have a Hyperlink on excel that opens a page in IE that I use to print it, but i want some kind of command in excel that does this to me automatically. (I click the link on excel and the file prints automatically through the web.)

Some Ideas?

Thank you!

]]>I have a Hyperlink on excel that opens a page in IE that I use to print it, but i want some kind of command in excel that does this to me automatically. (I click the link on excel and the file prints automatically through the web.)

Some Ideas?

Thank you!

Hey Everyone,

I'm trying to come up with a formula that will take a date from a certain cell, look at a drop down list (Monday to Sunday) and then return the next available selected Weekday.

IE: If I typed in June 2nd 2017 (Friday), selected Monday on the drop down, the value should return as June 5th 2017 (Monday).

This is what I am currently using, it kinda works, but I noticed that it is skipping a week sometimes.

=IF(AND($J$26="Abroad",$J$27="Wednesday"),$F$25+7-MOD(4+WEEKDAY($F$25,2),7),

IF(AND($J$26="Abroad",$J$27="Tuesday"),$F$25+6-MOD(4+WEEKDAY($F$25,2),7),

IF(AND($J$26="Abroad",$J$27="Monday"),$F$25+5-MOD(4+WEEKDAY($F$25,2),7),

IF(AND($J$26="Abroad",$J$27="Thursday"),$F$25+8-MOD(4+WEEKDAY($F$25,2),7),

IF(AND($J$26="Abroad",$J$27="Friday"),$F$25+9-MOD(4+WEEKDAY($F$25,2),7),

IF(AND($J$26="Abroad",$J$27="Saturday"),$F$25+10-MOD(4+WEEKDAY($F$25,2),7),

IF(AND($J$26="Abroad",$J$27="Sunday"),$F$25+11-MOD(4+WEEKDAY($F$25,2),7),$F$25)))))))

I noticed that when I put in June 1st (Thursday) and select Friday in the dropdown, it will return June 9th (Friday) instead of June 2nd (Friday) skipping a week.

Any help would be greatly appreciated!

]]>I'm trying to come up with a formula that will take a date from a certain cell, look at a drop down list (Monday to Sunday) and then return the next available selected Weekday.

IE: If I typed in June 2nd 2017 (Friday), selected Monday on the drop down, the value should return as June 5th 2017 (Monday).

This is what I am currently using, it kinda works, but I noticed that it is skipping a week sometimes.

=IF(AND($J$26="Abroad",$J$27="Wednesday"),$F$25+7-MOD(4+WEEKDAY($F$25,2),7),

IF(AND($J$26="Abroad",$J$27="Tuesday"),$F$25+6-MOD(4+WEEKDAY($F$25,2),7),

IF(AND($J$26="Abroad",$J$27="Monday"),$F$25+5-MOD(4+WEEKDAY($F$25,2),7),

IF(AND($J$26="Abroad",$J$27="Thursday"),$F$25+8-MOD(4+WEEKDAY($F$25,2),7),

IF(AND($J$26="Abroad",$J$27="Friday"),$F$25+9-MOD(4+WEEKDAY($F$25,2),7),

IF(AND($J$26="Abroad",$J$27="Saturday"),$F$25+10-MOD(4+WEEKDAY($F$25,2),7),

IF(AND($J$26="Abroad",$J$27="Sunday"),$F$25+11-MOD(4+WEEKDAY($F$25,2),7),$F$25)))))))

I noticed that when I put in June 1st (Thursday) and select Friday in the dropdown, it will return June 9th (Friday) instead of June 2nd (Friday) skipping a week.

Any help would be greatly appreciated!