Kapalı

Recap Ecel worsheet

having difficulty changing this macro to sorts on an excel protected worksheet

Private Sub WhichWeek()

'

' WhichWeek Macro

' Macro recorded 4/1/2014 by Tony

'

'

[login to view URL]

[login to view URL] Reference:="PreCopyToThisWeek"

[login to view URL] Down:=-8

[login to view URL]

Range("B11").Select

[login to view URL] Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _

:=False, Transpose:=False

[login to view URL] = False

[login to view URL] Key1:=Range("B11"), Order1:=xlAscending, Key2:=Range( _

"C11"), Order2:=xlDescending, Header:=xlNo, OrderCustom:=1, MatchCase:= _

False, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal, DataOption2 _

:=xlSortNormal

[login to view URL] Reference:="OneDecimalPlace"

[login to view URL] = "#,##0.0_);[Red](#,##0.0)"

Range("a1").Select

Range("b10").Select

Range("b1").Select

[login to view URL]

End Sub

Beceriler: .NET, C# Programlama, Excel, Yazılım Mimarisi, Visual Basic

Daha fazlasını gör: google maps infowindow operation, network operation demonstration video, picklistjs operation aborted, summary sheet in excel format, consolidate worksheets wizard, how to consolidate data in excel from multiple workbooks, excel front sheet, summary sheet in excel definition, combine multiple excel sheets into one sheet, merge sheets in excel, excel summary sheet multiple worksheets, vedio heart operation, aspcalendar client operation, operation system joomla, operation manual template technical, operation block port vbnet, network operation source code vbnet, transfer operation location, surgical operation simulator, modal ajax operation

İşveren Hakkında:
( 0 değerlendirme ) Providence, United States

Proje NO: #18989075

Bu iş için 19 freelancer ortalamada $26 teklif veriyor

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( Daha Fazla

$50 USD in 0 gün içinde
(677 Değerlendirme)
8.4
schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(323 Değerlendirme)
7.8
P0L

Hello, I’m an Excel VBA expert and I can fix your macro. Please check my profile and contact me to discuss further details. Regards.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(283 Değerlendirme)
7.2
dgled

Hi, I can do it for you now. I am an expert and guru in Financial, Math and Excel/VBA/Macro. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(76 Değerlendirme)
7.0
ksriniravi

Greetings! Being a full time freelancer working exclusively on Excel based projects, I work on such Excel based tasks every single day. Please share the file - I can fix the code to work with data. I have 18 year Daha Fazla

$15 USD in 0 gün içinde
(175 Değerlendirme)
6.8
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews, they speak for themselves. Best rega Daha Fazla

$15 USD in 0 gün içinde
(221 Değerlendirme)
6.9
zebracaro

I can do it for you quickly and exactly . Please contact me for saving your tie and your money .

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(119 Değerlendirme)
6.7
adeelpirzada

Hello its my pleasure to meet you I see you want to update your website using ASP.NET. I read your application carefully and I see I am a good fit for this work. I have 6 years experience in web development, 4 year Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(32 Değerlendirme)
6.1
periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered seventy five excel vba projects in the last one year. Willing to take up your project. Thank you, Regards.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(96 Değerlendirme)
6.2
vbexcel

Hi; I can get this done for you today. Please see my Portfolio for samples of my work. Regards Zenon

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(36 Değerlendirme)
5.6
shahinrahimi

I can help you. I have rich experience in excel and VB, and I do my best to save your time and pocket. Please feel free to contact me. MySkills: • Data Management ..............................{Excel, Matlab} • Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(15 Değerlendirme)
3.6
ielucerotrad1

I can do the job! I would suggest some changes to make it not necessary to select ranges. (more solid coding and less prone to errors) I'm an engineer with advanced working knowledge and experience in Excel and VBA in Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(6 Değerlendirme)
2.4
FD4CAST

Hi There, I have been coding VBA automation tools in Excel, Access & SQL since 2005. I can work on this today for you, and complete within 1 hours. it is very easy VBA. Please see my case studies and website Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(2 Değerlendirme)
1.8
coppercoder

send me some data and i will fix, test and send back tonight

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)
1.9
liejuni

Hi, is the problem, when you sort the data, the title got sort as well?? if yes, replace your macro [login to view URL] Key1:=Range("B11"), Order1:=xlAscending, Key2:=Range( _ "C11"), Order2:=xlDescending, Heade Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)
0.8
KimHyokJun

Hello there!!!!!!. I have read your description carefully. i have wealthy experience for this part If you employ me, I`ll do my best for you and perhaps I will satisfy you by my creative work. I want to discuss Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(2 Değerlendirme)
0.6
pogodin

Hello ! My experience with vba is more than 10 years. Can You clarify what difficulty with worksheet and provide examples of xls files ? Thank You. Regards, Alexei.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
DeltaIntelitech

Dear Prospect Client, I hope you are doing well! I am very good at VBA/Macro and Excel. I have 11+ years of experience working with multiple MNCs in the same profile (Data Processing/Integration/Validation/Cleansin Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
TumblingWave

Hello, I can look at this for you. I have many years of Office macro experience. I am just finishing an Office macro project, awarded to me as follows: https://www.freelancer.com/projects/word/CREATE-SIMPLE-WORD-MA Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0