Suoritettu

Write VBA copy/paste loop based on cell_check restriction

See attached file, I want a macro run that achieves the following when run:

- Clears any existing data in the "DATA" worksheet below the headings in row 2;

- Loops through the worksheets "ROSTER - ADMIN", "ROSTER - CARE" & "ROSTER HOSPITALITY" and where the value of the cell in column A is 1 transposes as values the information in the roster worksheet to the "DATA" worksheet among the various headings.

As an example of the transposition the current file will paste the following from the Roster Admin Worksheet:

- Dates from F4:L4 of ROSTER - ADMIN to B3:B9 in DATA;

- Employee from F6:L6 ROSTER - ADMIN to E3:E9 in DATA;

- Start Time from F7:L7 ROSTER - ADMIN to F3:F9 in DATA;

- Finish Time from F8:L8 ROSTER - ADMIN to G3:G9 in DATA;

- Break (Hours) from F9:L9 ROSTER - ADMIN to H3:H9 in DATA;

- Hours from F10:L10 ROSTER - ADMIN to I3:I9 in DATA;

- the Value in Column C of ROSTER - ADMIN to C3:C9 in DATA;

- the Value in Column D of ROSTER - ADMIN to D3:D9 in DATA;

As the value in the ROSTER - ADMIN worksheet from A11:A15 is zero it will ignore the next range and move onto the ROSTER - Care worksheet and transpose in a similar fashion to the DATA worksheet below what has been transposed from the ROSTER - ADMIN Worksheet.

Please review and understand the brief before submitting a proposal, need within the next 6 hours.

Taidot: tiedonsyöttö, Excel, Visual Basic, Visual Basic for Apps

Näytä lisää: vba copy paste object, copy paste web based excel spreadsheet, access 2003 vba copy paste report, word vba copy paste table row, vba copy paste user password, access vba copy paste forms, access vba copy paste table, vba copy paste, vba copy paste table, vba copy paste whole form, vba copy paste csv, macro copy rows excel based cell content, access vba copy paste program, project vba copy paste, vba copy paste rows excel, vba copy paste msaccess

Tietoa työnantajasta:
( 26 arvostelua ) Adelaide, Australia

Projektin tunnus: #19243131

Myönnetty käyttäjälle:

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 ( Lisää

$60 AUD 0 päivässä
(691 Arvostelua)
8.4

13 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

SojolIslam21

Hello Dear Client I am new and regular freelancer. I have many experiences on your project. You want to hire me with a cheap rate. Because I can not reduce the rate of money in the freelancer's bid, so I'll do your wor Lisää

$10 AUD 1 päivässä
(0 arvostelua)
0.0
Harsh72169

i can do your work .......... ........ Lisää

$25 AUD 1 päivässä
(0 arvostelua)
0.0
evonsystems7

"Hi, Hope you are doing well! Thanks for sharing your project requirement with us. It will be our great pleasure to work on your project. I have checked your requirement, yes we can do it, because we already work on si Lisää

$34 AUD 7 päivässä
(0 arvostelua)
0.0
yoyo09

Hello, Hope you are doing great!! I have read and understood the description I am absolutely sure that I can do the project very well. Please provide more details so I can make sure about scope of work. best regards

$20 AUD 1 päivässä
(0 arvostelua)
0.0
aarthysha

try my service and tell me how i work ,without an opportunity how can i prove ......................

$25 AUD 1 päivässä
(0 arvostelua)
0.0
ldelaney90

I am a fast worker, I can type well and I used to work as a receptionist for Holden. I currently work as a casual disability support worker I am a full time mum looking for ways to increase income. Relevant Skills and Lisää

$35 AUD 1 päivässä
(0 arvostelua)
0.0
jyx012

Hello good day! I would like to apply to this project. I'm sorry I don't have any port folio to show to you because i am new to this kind of field as a freelancer. But rest assured I'll do my best to learn. Thank Lisää

$25 AUD 1 päivässä
(0 arvostelua)
0.0
$25 AUD 1 päivässä
(0 arvostelua)
0.0
VishalAgrawal11

Hi,I have read your requirements Write VBA copy/paste loop based on cell_check restriction and I’m pretty confident that I will be able to get your work done within the given time your requirements conclude.I am very Lisää

$25 AUD 1 päivässä
(0 arvostelua)
0.0
shalinibharti803

I will work hard .i [login to view URL] work within limited period lf time.

$25 AUD 1 päivässä
(0 arvostelua)
0.0
Saitejab16

I can do as soon as possible

$25 AUD 1 päivässä
(0 arvostelua)
0.0
Luthercheu1129

Dear Employer, I'm detail-oriented and a very reliable people with good education background and working experience. I'm very sufficient in excel and VBA skills. I ensure you I'm the best choice for you to complete yo Lisää

$25 AUD 1 päivässä
(0 arvostelua)
0.0