Slutfört

Make VBA code

Hello,

I have a multiple changing values in multiple sheets what I want is to make a button that type all numbers that are connected to foumula to non formula cells for example:

Name: [login to view URL]

Views: 13

Size: 209.9 KB

I want a button that when pressed all values that resulted from formula in cells (C33:K33) to be typed to (C2:K2) with no formula and can be removed when needed also I want it to

affect a number of 6 similiar sheets contain the same table simulatanuosly

I searched the web and had this code :

im xVal As String

'Update by Extendoffice 2018/8/22

Private Sub Worksheet_Change(ByVal Target As Range)

Static xCount As Integer

[login to view URL] = False

If [login to view URL] = Range("C2").Address Then

Range("D2").Offset(xCount, 0).Value = xVal

xCount = xCount

Else

If xVal <> Range("C2").Value Then

Range("D2").Offset(xCount, 0).Value = xVal

xCount = xCount

End If

End If

[login to view URL] = True

End Sub

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

xVal = Range("C2").Value

End Sub

But the problems of this code is :

1- It only affect one cell and I want it to affect a range of cells

2- It changes (D2) whenever c2 changes not when i want it to type the number (press the button)

3- it affect only one sheet and I want it to affect 8 sheets

What I need to be done:

1- Make button 1 run the following function :

For sheet L.E. : Write the values of range (C33:K33) in (C2:K33) -- (Not using formula)

For sheet U$ : Write the values of range (B24:H24) in (B2:H2) -- (Not using formula)

For sheet EURO : Write the values of range (B24:H24) in (B2:H2) -- (Not using formula)

For sheet GBP : Write the values of range (C24:F24) in (C2:F2) -- (Not using formula)

For sheet SAR : Write the values of range (B24:I24) in (B2:I2) -- (Not using formula)

For sheet AED : Write the values of range (B24:H24) in (B2:H2) -- (Not using formula)

For sheet KWD : Write the values of range (B24:G24) in (B2:G2) -- (Not using formula)

For sheet CHF : Write the values of range (B24:G24) in (B2:G2) -- (Not using formula)

Please note :

all values in 2nd ROW must be editable before or after button is pressed and when button pressed the values are written to row 2 in the 8 sheets (not using= formula)

Thanks

[login to view URL]

Kompetens: Databehandling, Excel, Visual Basic, Visual Basics för apps

Visa mer: vba language, useful vba codes for excel, how to create a macro in excel 2013, how to create a macro in excel 2010, excel vba programming pdf, how to create a macro in excel 2007, vba excel, how to create a macro in excel 2016, vba code create xml, vba code string gzip, tsv msaccess vba code, excel vba code optmization, vba code generate report excel, vba code check html link valid, vba code create pdf file access 2007 report, resize jpg vba code, excel vba code optimis, processor access vba code, vba code extract email text field, downloading vba code

Om arbetsgivaren:
( 0 omdömen ) Port Said, Egypt

Projekt-id: #18512814

Tilldelades:

Mokshith30

Hi I have Read Your Requirements I am Excel VBA Expert Experianced in VBA Macros & Web Scraping Script... I can finish any kind of vba task in 1 day only pls see my previous projects for my vba experiance T Mer

$15 USD inom 0 dagar
(12 omdömen)
3.2

8 frilansare har i genomsnitt lagt bud på $42 för detta jobb

schoudhary1553

Dear project manager, Hope you are doing well. I am working here from last 4 years full time and deliver almost 425 jobs with 100% client satisfaction. Please see my profile reviews . I have more than 6 years of Mer

$100 USD inom 2 dagar
(303 omdömen)
7.7
fatimatuzzohura

Hi, I am experienced on Microsoft Access , Excel and VBA, Powerpoint. I can start your job immediately also. Please contact me to discuss the project in details. Thanks

$100 USD inom 1 dag
(138 omdömen)
6.3
akritisood94

I have 4 yrs in Programming, Automation & more importantly delivering projects as required & in quick turn around time. I work full time as Freelancer & Blogger. I will be able to start your work immediately. My Main S Mer

$25 USD inom 1 dag
(29 omdömen)
4.9
anshsparkle

HELLO I CAN START RIGHT NOW - I AM EXPERT IN Data Processing Excel and I BET YOU CANNOT FIND BETTER FREELANCER THAN ME ... pLEASE MESSEGE ME AND LETS DISCUSS THE THINGS THANKS

$25 USD inom 1 dag
(1 omdöme)
3.0
SamerHany

Hi there, I have 5+ years of experience in MS Excel and VBA programming. The code attached runs every time a cell changes, but, it only affects cell "D2" whenever cell "C2" changes. I can complete the required task Mer

$15 USD inom 1 dag
(3 omdömen)
0.4
punhal028

Respected Sir/Madam, Hope you are doing well. Hey, I'm interested in your project. Please send me a message so that we can discuss more. I really confident that, I can do this task very effectively. I have some good Mer

$30 USD inom 1 dag
(0 omdömen)
0.0
$25 USD inom 1 dag
(0 omdömen)
0.0