Search results

Please give me some time to learn it and then come back to you, I appreciate for writing all this to me. GN0001

Hello Team, I have posted this question before, but I don't have an answer to take care of my task. -I have a time sheet and I need to pull data from that sheet and populate Destination Sheet. -Data which is across rows has to run vertically down a column. -For example in row 3 in time sheet...

Xen, I have uploaded the file. GN0001

Hello Xen, I have uploaded the files. Please remember that when your formula doesn't work after some rows. When I evaluate the formula it gives a row number like 25. Row 25 doesn't have anything. Time sheet has only 13 rows. Regards, GN0001

I can't upload the file, unfortunately, but when you go to row 100, the function can't capture the time sheet rows.

Unfortunately, It didn't work, you can see that when we go to row 100, it returns a row which is out of what I have in April WK_April_1-6. My timesheet has only 13 rows and your formula wants to capture data out of row 13, moreover, I get a lot of zeros, how can I manage it? Regards, GN0001

I will be home in two three hours ans I will post my file thanks I hope I can get an answer today. GNooo1

It didn't work at all, since we I go to row 45 and then we deduct 2 of it, then on the first week sheet we don't have that row. I will writer you in detail once I am home. Thanks GN0001

Hello Xen, My time sheets have the same name. I think I am equipped enough to take care of this task. By the way, you need to type those ' (apostrophes) if you are using first version of solution and your worksheet name contains spaces, I fixed that in last version so you can just type the...

This seems very insteresting, I would like to learn it. If I have a chance, I will be back to this. Thank you for providing this to me. GN0001

Thank you very much for the answer provided. I might have more questions on this. GN0001

Naryan, The code worked for me, Thank you very much. But can you talk about it to see what it does (I mean the part below)? I have understood it partially. If Len(Me.TextBox1.Value) Then Set rng = Worksheets("Sheet2").Range("A1" & ":" & "A" & Worksheets("Sheet2").Range("A" &...

Hello Xen, Thank you very much for all. Last night I was up til 3:30 a.m. to put the piece together to understand. I am trying to learn your first solution. After I get mastery, I will go ahead and learn more the second solution. -If time sheet starts from 10, you will have to modify this...

------------------------------------------------------------------------------ Hello Xen, I understood all the questions that I have made, however I need to evaluate the formula more. I need clarification on several points. Question 2, I understand that you made B2 for test, you have deducted...

Xen, It is amazing. I understand it partially, I did evaluate formula to understand what it does, however some of them is not clear form me: 1-COUNT(INDIRECT(B1&"!"&"1:1")) -What is this part (B1&"!"&"1:1"))? I know it counts the number of days...

Please look at the Time sheet worksheet. I need the data to be entered and restructured as in destination work sheet. Please remember each sheet has different number of projects, some have two projects and some have 10 projects. By the way, do you know what is that being shown on the top of...

Hello team, I have to paste lots of rows to another workbook, the first workbook is a time sheet. it has columns as: project name, sub project, days of the week and date (which is the first week of April). If a project Manager has worked on a project on Monday, Tuesday and Wednesday (days are...

That's it...!. I really like it. Thank you so very much. Warm regards, GN0001

Hello Sir JB7, I appreciate your time for writing this code. unfortunately, I don't have any knowledge of VBA code. However I will keep this code in my library to go back to that in the Future. GN0001

Hello Narayan, Thank you for the response, This select the range AA3 through AA17 , and do a Copy + Paste Special , Values , so that instead of the formulae =F3 , =F11 and =F17 , only the values are present. doesn't work, It says that copy area and paste area is not the same. I think this...

Hello Debraj, How can I skip blanks? Regards, GN0001

Hello SirJB7, Because I want to copy the formula results and paste as value over itself. For example I have done a VLookUp, I have some returned values and some #NA, I filter on returned values and I need to copy and paste returned values over themselves. I can paste to a different column (one...

SirJB7, Yes I am pasting over itself. Please save me from this frustration. Regards, GN0001