need your help

%3CLINGO-SUB%20id%3D%22lingo-sub-1716806%22%20slang%3D%22en-US%22%3Eneed%20your%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1716806%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Everybody%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20name%20is%20Ayed%2C%3C%2FP%3E%3CP%3EI%20have%20some%20problems%20and%20i%20need%20your%20help%20to%20fix%20them%3C%2FP%3E%3CP%3E1-%20I%20want%20to%20change%20the%20defult%20net%20browser%20from%20the%20excel%3C%2FP%3E%3CP%3Ebecause%20when%20i%20want%20to%20import%20data%20from%20the%20internet%20it%20refuse%20my%20broswer%20and%20says%20you%20have%20to%20update%20the%20broswer%20while%20it%20is%20updated%20with%20all%20broswers.%3C%2FP%3E%3CP%3E2-%20I%20want%20to%20know%20how%20to%20copy%20automaticlly%20data%20from%20the%201st%20sheet%20to%20all%20sheets(in%20the%20first%20sheet%20i%20programm%20it%20to%20referesh%20the%20data%20automaticlly%20when%20i%20open%20it%20).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20and%20i%20will%20be%20waiting%20your%20help%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1716806%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1717866%22%20slang%3D%22de-DE%22%3ESubject%3A%20need%20your%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1717866%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F810361%22%20target%3D%22_blank%22%3E%40ayed8748%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%223%22%3E1.%20Change%20your%20default%20browser%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%223%22%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-gb%2Fhelp%2F4028606%2Fwindows-10-change-your-default-browser%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-gb%2Fhelp%2F4028606%2Fwindows-10-change-your-default-browser%3C%2FA%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CUL%3E%3CLI%3E%3CFONT%20size%3D%223%22%3E%3CSPAN%20class%3D%22ng-isolate-scope%22%3E%3CSPAN%20class%3D%22ng-scope%22%3ESelect%20the%20%3C%2FSPAN%3E%20%3CSTRONG%3EStart%3C%2FSTRONG%3E%20%3CSPAN%20class%3D%22ng-scope%22%3Ebutton%2C%20and%20then%20type%20%3C%2FSPAN%3EDefault%20%3CSTRONG%3Eapps%3C%2FSTRONG%3E%3CSPAN%20class%3D%22ng-scope%22%3E.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FLI%3E%3CLI%3E%3CFONT%20size%3D%223%22%3E%3CSPAN%20class%3D%22ng-isolate-scope%22%3E%3CSPAN%20class%3D%22ng-scope%22%3EIn%20the%20search%20results%2C%20select%20%3C%2FSPAN%3E%20%3CSTRONG%3EDefault%20apps%3C%2FSTRONG%3E%3CSPAN%20class%3D%22ng-scope%22%3E.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FLI%3E%3CLI%3E%3CP%20class%3D%22ng-scope%20x-hidden-focus%22%3E%3CFONT%20size%3D%223%22%3EUnder%20%3CSTRONG%3EWeb%20browser%3C%2FSTRONG%3E%2C%20select%20the%20browser%20currently%20listed%2C%20and%20then%20select%20Microsoft%20%3CSTRONG%3EEdge%3C%2FSTRONG%3E%20or%20another%20browser.%3C%2FFONT%3E%3C%2FP%3E%3C%2FLI%3E%3C%2FUL%3E%3CP%3EIs%20it%20possible%20to%20use%20Edge%20or%20Chrome%20from%20Excel%20when%20importing%20data%20from%20a%20website%20(Data%20%26gt%3B%20New%20Query%20%26gt%3B%20From%20Other%20sources%20%26gt%3B%20From%20Web)%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsocial.technet.microsoft.com%2FForums%2Foffice%2Fen-US%2F6b2d846f-300f-4593-8197-0e77ccbff496%2Fexcel-default-browser%3Fforum%3Dexcel%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsocial.technet.microsoft.com%2FForums%2Foffice%2Fen-US%2F6b2d846f-300f-4593-8197-0e77ccbff496%2Fexcel-default-browser%3Fforum%3Dexcel%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2.%20%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EThere%20are%20several%20ways%20to%20do%20this%2C%20one%20of%20which%20is%20VBA.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3ESub%20Copy_data()%0ADim%20Quelltab%20As%20Worksheet%0ADim%20Zieltab%20As%20Worksheet%0ADim%20Zelle%20As%20Range%0ADim%20Zaehler%20As%20Long%0AZaehler%20%3D%201%0ABereich%20%3D%20%22A1%3AA10%22%0ASet%20Quelltab%20%3D%20ActiveWorkbook.Worksheets(%22Sheet1%22)%0ASet%20Zieltab%20%3D%20ActiveWorkbook.Worksheets(%22Sheet2%22)%0AFor%20Each%20Zelle%20In%20Quelltab.Range(%22A1%3AA10%22)%0A%20Zieltab.Cells(Zaehler%2C%201)%20%3D%20Zelle%0A%20Zaehler%20%3D%20Zaehler%20%2B%201%0ANext%20Zelle%0AEnd%20Sub%0A'as%20posible%2C%20from%20German%20in%20English%20translate.%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%222%22%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20%3C%2FFONT%3Emembers%20reading%20%3CFONT%20size%3D%222%22%3Ehere.%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello Everybody

 

My name is Ayed,

I have some problems and i need your help to fix them

1- I want to change the defult net browser from the excel

because when i want to import data from the internet it refuse my broswer and says you have to update the broswer while it is updated with all broswers.

2- I want to know how to copy automaticlly data from the 1st sheet to all sheets(in the first sheet i programm it to referesh the data automaticlly when i open it ).

 

 

Thank you and i will be waiting your help

3 Replies

@ayed8748 

 

1. Change your default browser

https://support.microsoft.com/en-gb/help/4028606/windows-10-change-your-default-browser

 

  • Select the Start button, and then type Default apps.
  • In the search results, select Default apps.
  • Under Web browser, select the browser currently listed, and then select Microsoft Edge or another browser.

Is it possible to use Edge or Chrome from Excel when importing data from a website (Data > New Query > From Other sources > From Web)

https://social.technet.microsoft.com/Forums/office/en-US/6b2d846f-300f-4593-8197-0e77ccbff496/excel-...

 

2. There are several ways to do this, one of which is VBA.

 

Sub Copy_data()
Dim Quelltab As Worksheet
Dim Zieltab As Worksheet
Dim Zelle As Range
Dim Zaehler As Long
Zaehler = 1
Bereich = "A1:A10"
Set Quelltab = ActiveWorkbook.Worksheets("Sheet1")
Set Zieltab = ActiveWorkbook.Worksheets("Sheet2")
For Each Zelle In Quelltab.Range("A1:A10")
 Zieltab.Cells(Zaehler, 1) = Zelle
 Zaehler = Zaehler + 1
Next Zelle
End Sub
'as posible, from German in English translate.

 

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

 

Hello Boss @Nikolino 

 

I tried to do the same what did you explain but id doesn't come

 

i update the offce but still the same

may be i need to explain more for you to help me

 

if you don't mind send to me privately how can i contact you and do all by sharring the screen or anyway

 

 

thank you for your help

@ayed8748 

 

!.

If you want to set your Own Browser as a default web browser.

On your computer >> Click Start menu >> Click Settings .

Open your default apps >> Original version >> Click System Default apps.

At the bottom, under "Web browser," click your current browser >> "Choose an app" window >> Click or select your own browser.

 

 

2.

Open the VBA editor in Excel

It is very easy to open the VBA editor in Excel and then use it to create some macros. Simply press the key combination [Alt] + [F11].
You can watch youtube videos on how to do this, you will find a lot about "first steps in VBA".
Don't forget to save the file as an .xlsm file at the end of the VBA code.


Attached is a workbook where the code is already inserted.
If you get stuck, you have the option to click on my profile and send me a private message.

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.