Thanks for reply Anil. Is I informed in trailer mail that, I have 4-5 files like this and I need to do the same process in all the files, which will be a lengthy process, hence asked for help.
Regards Pravin Gunjal. ---------- Forwarded message ---------- From: अनिल नारायण गवली <gawlianil8...@gmail.com> Date: Mon, Apr 1, 2013 at 11:18 AM Subject: Re: $$Excel-Macros$$ Fwd: Unique data is required in all the sheets by macro To: "excel-macros@googlegroups.com" <excel-macros@googlegroups.com>, Pravin Gunjal <isk1...@gmail.com> Dear Pravin, u can use it from Group option. Select the sheet by clicking the sheet name & by pressing shift buton goto last sheetname it automatically select all the sheets and now u can edit the very first sheet simultaneously the other sheets will be updating. like a carbon copy. Warm Regards, Gawli Anil On Mon, Apr 1, 2013 at 9:52 AM, Pravin Gunjal <isk1...@gmail.com> wrote: > *Hope to get some help.* > > ---------- Forwarded message ---------- > From: Pravin Gunjal <isk1...@gmail.com> > Date: Sun, Mar 31, 2013 at 11:21 AM > Subject: Fwd: $$Excel-Macros$$ Fwd: Unique data is required in all the > sheets by macro > To: Rahim Zulfiqar Ali - Excel <rahim.zulfiqar...@gmail.com>, Rahim > Zulfiqar Ali <spreadsheetconsultancy...@gmail.com> > > > Dear Rahim, > > > Can you help me in some extent, I have 4-5 files containing many sheets > with unique data in each file and in all the sheets I need some changes as > given below :- > > > > I have attached a sample file here for immediate reference :- > > > > 1) In all sheets we have to insert three rows at the top. > > > > 2) In first row we need to write. “*Hospin Sales Targets for the year > 2013-2014*” > > -> It can be changed later on based on the requirement in all the sheets. > > > > 3) In Second row we will have to write as: *“Name: __________ HQ: > __________ Division: __________ Region: __________ Zone: __________”* > > -> These data must be typed in different columns by leaving one empty > row so that end user can fill this data as required. > > > > 4) I need to merge the total value cells (e.g. I5 has to be merged > with H5 in all the sheets; K5 with J5; I11 with H11) i.e. wherever there a > value columns in all the sheets, must be merged with it’s left side column > and then all the value columns are to hide in all the sheets) > > > > 5) And all the quantities are to be updated with round formula. Pl > refer cell “L3” where the qty is mentioned as 7639.2 which should be as > 7639. > > > > I know this is a very big stuff, hoping that someone helps me to get it > done, otherwise I must do it manually. > > > > Please do the needful. Thank you, > > > > Regards, > > Pravin Gunjal** > > > > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 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) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- Thanks & Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
