Hi Siraj, You mean row 8 or row 7. Row 7 would include row headers... Before running the code, if you clear-content Report Index from row 8 to anywhere, the code will place your data there. If you don't clear it, it will place it from bottom. You should tell if you want to clear the previous data, without knowing, I assume you don't want to and I just append the data to the previous one. ... In the main sub if you change wsB.Cells(cnt + i, j + 1).Value = TabFin(i, j) to wsB.Cells(8 + i, j + 1).Value = TabFin(i, j) it will place your data from row 8 until there is something HOWEVER, if you haven't cleared it first, if you have less data than the previous time you run the code, there might still be some data in the bottom.
Pascal On Sat, Apr 21, 2012 at 3:24 PM, Siraj Momin (BTG) <smo...@ccc.ae> wrote: > Dear Pascal**** > > ** ** > > Sorry for the delayed reply, I was testing the macro on my actual data > your macro is working fine on file which I send before but on actual data > some problem may be I did not able to explain you properly before, actually > I just want to match the value of sheet “REPORT-INDEX” column *I1* which > will be always changing value with the value in “PROGRESS TRACKING-DATA” > column P(NAMED col16) and return the values of matching heading in PROGRESS > TRACKING-DATA(row 1) with REPORT-INDEX (row7), may be you can change the > code attached is the latest file**** > > ** ** > > I am using drop down in (F1,F2,F3,F5) in sheet REPORT-INDEX and I am > using concatenate formula in Column I1 which combines (F1,F2,F3,F5) in > sheet REPORT-INDEX, so we need to match only on one column I1 with value in > “PROGRESS TRACKING-DATA” column P(NAMED col16) and return the value.**** > > ** ** > > Hope I am able to explain you better now. Still I am not able to send you > complete data in PROGRESS TRACKING-DATA because of group size limi**** > > ** ** > > ** ** > > Thanks for your best efforts..**** > > ** ** > > ** ** > > Siraj > -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
