+ Reply to Thread
Results 1 to 54 of 54

macro/vba to divide data sheet into two sheet

  1. #1
    Registered User
    Join Date
    10-11-2020
    Location
    India
    MS-Off Ver
    2013
    Posts
    36

    macro/vba to divide data sheet into two sheet

    Need to divide the data in data sheet into two sheets

    1)Only those records should move to the newly created two sheets in which the Date of birth is in DD-MMM-YY format(12-Nov-15).Records where the date of birth is not in said format or is 0,blank,text, numbers etc should get skipped.

    2)In the newly created two sheets the value visible in original data sheet should get pasted, and the formula should not get pasted.

    3)Input box for, which columns I want to be copied to new sheets (As all the columns need not be copied).Not in term of header but column name like A,B,C,H,I,J

    4)input box for, row range for each new sheet (like row 2-400 to sheet1, 450-650 to sheet2).It is not not necessary that all the data will be get divided into two sheets, so the row range for 2nd sheet should not get auto fixed by selection of row range for first sheet. e.g It may happen that records between row 5 to 400 will go to one sheet and records between row 450 to 600 will go to second sheet, rest of record need not be copied to either of sheet.

    5)input box to, name the newly created two sheet

    6)input box for, name of workbook to which I want to move these newly created sheets and provision for error message if the workbook to which I want to move these sheets is not open.

    Thanks
    Attached Files Attached Files
    Last edited by gautam5; 10-17-2020 at 12:15 PM.

  2. #2
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: macro/vba to divide data sheet into two sheet

    Here is a first iteration of your requirements. The tool does not yet select only the columns picked, but all the columns up to the last selected column. As per removing inaccurate dated items, the code still does not do that.

    Please Login or Register  to view this content.
    Last edited by maniacb; 10-13-2020 at 02:19 PM.

  3. #3
    Registered User
    Join Date
    10-11-2020
    Location
    India
    MS-Off Ver
    2013
    Posts
    36

    Re: macro/vba to divide data sheet into two sheet

    Thank you for your brilliant effort.Few issues i observed
    a) can it paste the value instead of formula
    b)is it mandatory to keep the date column in column B always.
    c)in the top row can it paste the column name of original sheet from which the data got imported,so that I can relate to what data is in what column.
    d) what is the use of end date 1-Jan-2017 .Is it like the end date should not be older to 1-jan-2017
    e)
    Please Login or Register  to view this content.
    what is Vbnewline?
    and "at least a,b " does it mean like a,b columns are mandatory.
    f)it pastes the column to sheet 1 successfully but the sheet 2 remains blank
    g)after entering all the details like row no, column names a box named "update values:XXXXXXX" pop ups .What is the purpose of same

    Again, thanks for your effort man.
    Last edited by gautam5; 10-13-2020 at 01:22 PM.

  4. #4
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: macro/vba to divide data sheet into two sheet

    Working on your observations, but note I repaired item f by editing the code, e) vbnewline is a line break. You shouldn't see it. Resolved with my last edit of code
    Last edited by maniacb; 10-13-2020 at 02:21 PM.

  5. #5
    Registered User
    Join Date
    10-11-2020
    Location
    India
    MS-Off Ver
    2013
    Posts
    36

    Re: macro/vba to divide data sheet into two sheet

    I recognize and am thankful for your effort. I am new to coding but have modified the code little bit. The date column being shifted to "N" in my code.The 2nd sheet remains blank. The first sheet is getting copied ok .
    Please Login or Register  to view this content.

  6. #6
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: macro/vba to divide data sheet into two sheet

    Response:
    a) fixed
    b) yes, the way it is written right now
    c) Repaired
    d) what is the use of end date - I use to filter out irrelevant dates. Same with start dates
    e) fixed
    f) repaired
    g) I don't see this pop up. Tell me if you still see it in this code

    I didn't understand why you changed to column N. But great if it works for you.

    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    10-11-2020
    Location
    India
    MS-Off Ver
    2013
    Posts
    36

    Re: macro/vba to divide data sheet into two sheet

    Thank you again.
    a)i)for date column:Is it possible to retain the original value as it is in the destination cell. i.e If in the cell of date column date is written as 21-Nov-19 it should get pasted as 21-Nov-19 in destination cell as well.Now it is getting converted to number. Also if there is a zero,text or any number it should get pasted as that , in short the value should get pasted as we see them in source cell. If this can be achieved, then that will solve most of my trouble.
    ii)for other column:If the value is in percentage can it get pasted as percentage
    b)please let me know if in future the date column changes to any other column than "B" then what changes I have to make in the code.
    c)it pastes data from row above .A column name will be sufficient ,if the data in original sheet from "j" column then it should write "j"
    d)it still pastes data other then date.
    e)thank you
    f)still checking

    Is it possible that if in destination workbook if sheets of same name which are being input exist then it will create sheet with name being input-1
    If i input sheet name to be created as "juniors" and "seniors" and if in destination workbook sheet with same name already exist then it will create sheet named "junior1" and "senior1"
    Thanks

  8. #8
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: macro/vba to divide data sheet into two sheet

    a) and ii) resolved with .PasteSpecial xlPasteValuesAndNumberFormats
    b) change "B" in code to whatever column has dates
    c) I think that is working, or I don't understand point
    d) work in progress
    e) your welcome
    f) ok
    Sheet Name request: work in progress

    I will update you on wip items asap

  9. #9
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: macro/vba to divide data sheet into two sheet

    Here is the latest code iteration. It should work to resolve the renaming if sheet exist and removing the non relevant dates. I say should because it works when I manually step through the code, but gives issues when I run it straight. Test it out

    Please Login or Register  to view this content.

  10. #10
    Registered User
    Join Date
    10-11-2020
    Location
    India
    MS-Off Ver
    2013
    Posts
    36

    Re: macro/vba to divide data sheet into two sheet

    Following issues appeared
    1)The data is not getting copied into second sheet (issue reappeared)
    2)blank cells and texts are not getting removed from date column. (the record(whole row) having blank cell or only text in date column should get deleted)

    Thanks again

  11. #11
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: macro/vba to divide data sheet into two sheet

    Alright, here you go. Fingers crossed

    Please Login or Register  to view this content.

  12. #12
    Registered User
    Join Date
    10-11-2020
    Location
    India
    MS-Off Ver
    2013
    Posts
    36

    Re: macro/vba to divide data sheet into two sheet

    Most of the things are done just few fine tuning needed
    1)when I was running the code it divided the wrong sheet many times and I was confused, then I noticed the code is written for "sheet1" and order of my sheet was changed. can u please change that to sheet name(instead of sheet number) "studump"?The sheet number may change but I can keep the sheet name constant. I tried to do it myself but ended up with error.
    2)If in destination sheet, sheet with same name exist instead of quitting it should create sheets with name assigned through input and suffixed by random numbers
    3)most of the unnecessary data is now getting deleted from date columns .Just need to delete decimal numbers.Please include decimal number in unnecessary data list for date column and delete record(row containing numbers with decimal point in date filed.
    4)To delete the unnecessary columns from both the newly created sheet I run the below given macro in both the sheets
    Please Login or Register  to view this content.
    can you integrate this code into the code written by you so that after importing the data this code will run in both the newly created sheet
    Also in future code please change date column from "B" to "O"
    Thanks again

  13. #13
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: macro/vba to divide data sheet into two sheet

    Lets see if this does it for you

    Please Login or Register  to view this content.

  14. #14
    Registered User
    Join Date
    10-11-2020
    Location
    India
    MS-Off Ver
    2013
    Posts
    36

    Re: macro/vba to divide data sheet into two sheet

    worked perfectly for first sheet. But again the data did not get copied to 2nd sheet. (problem reappeared).
    Need to put these into cells of first row of both newly created sheets A1=student_name,B1=P-Percentage,C1=Cumulative Marks,D1=enroll_Date,E1=K-Percentage,F1=S-value,G1=L-value
    Thanks
    Last edited by gautam5; 10-15-2020 at 10:59 AM.

  15. #15
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: macro/vba to divide data sheet into two sheet

    Can you provide a sample snippet of data in a sample workbook with all the columns so I can assign them from the start. Thanks
    Last edited by maniacb; 10-15-2020 at 01:17 PM.

  16. #16
    Registered User
    Join Date
    10-11-2020
    Location
    India
    MS-Off Ver
    2013
    Posts
    36

    Re: macro/vba to divide data sheet into two sheet

    The data columns ranges from A to around AV. Too long to take a screenshot. After deleting all the columns , these 7 columns will be what I will have to analyse .so after deleting all columns commands, naming the first row as given will do the trick.Attachment 699848
    Last edited by gautam5; 10-15-2020 at 01:11 PM.

  17. #17
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: macro/vba to divide data sheet into two sheet

    I am asking for a sample file with the columns showing so I can apply the code to what you will be applying it to.

  18. #18
    Registered User
    Join Date
    10-11-2020
    Location
    India
    MS-Off Ver
    2013
    Posts
    36

    Re: macro/vba to divide data sheet into two sheet

    The data formats keep changing (order of columns) that is why I needed a input box for columns. I will be also be changing the columns to be deleted time to time.But after deleting all columns these seven columns I will need at the end no matter what is order of the column at the beginning. So naming the header at the end will work.Also the header naming in original data sheet is too complex ,I prefer to use simple header that i can understand easily.
    Last edited by gautam5; 10-15-2020 at 02:02 PM.

  19. #19
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: macro/vba to divide data sheet into two sheet

    I suggest we make a question for which column has the dates, then select all the remaining columns through the existing input box. I’ll work on incorporating a better column selection process. Let’s call it a work in progress.

  20. #20
    Registered User
    Join Date
    10-11-2020
    Location
    India
    MS-Off Ver
    2013
    Posts
    36

    Re: macro/vba to divide data sheet into two sheet

    Yup. If we provide input box for the date column and move only those columns, which are selected then it will be great.Then we can then do away with delete column code also.
    I am trying to resolve the issue of data not being getting pasted to 2nd sheet, but getting errors. Also can we get the data trimmed(delete any preceding and following blank spaces) while pasting in new sheet.
    Thank you for your constant support.
    Last edited by gautam5; 10-16-2020 at 01:55 AM.

  21. #21
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: macro/vba to divide data sheet into two sheet

    what column has the untrimmed data? Working on the rest.

  22. #22
    Registered User
    Join Date
    10-11-2020
    Location
    India
    MS-Off Ver
    2013
    Posts
    36

    Re: macro/vba to divide data sheet into two sheet

    Names in name column sometimes prefixed or suffixed with blank spaces and using vlookup or match index on such entry given wrong result.The date column too.

  23. #23
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: macro/vba to divide data sheet into two sheet

    To carry out post 19, my only solution currently filters the bad data out of the source data, is that ok? And is A always the names?
    Last edited by maniacb; 10-16-2020 at 12:03 PM.

  24. #24
    Registered User
    Join Date
    10-11-2020
    Location
    India
    MS-Off Ver
    2013
    Posts
    36

    Re: macro/vba to divide data sheet into two sheet

    Thats ok.Yes A is always name

  25. #25
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: macro/vba to divide data sheet into two sheet

    Here is the new code. I added error trapping too. Trim not resolved yet.


    Please Login or Register  to view this content.

  26. #26
    Registered User
    Join Date
    10-11-2020
    Location
    India
    MS-Off Ver
    2013
    Posts
    36

    Re: macro/vba to divide data sheet into two sheet

    getting error."This is an error type mismatch".

  27. #27
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: macro/vba to divide data sheet into two sheet

    I get the mismatch error when I try to enter the column values without commas. Can you confirm you are using commas with column values?

  28. #28
    Registered User
    Join Date
    10-11-2020
    Location
    India
    MS-Off Ver
    2013
    Posts
    36

    Re: macro/vba to divide data sheet into two sheet

    affirmative.Using commas and still getting error.

  29. #29
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: macro/vba to divide data sheet into two sheet

    Here we go again More captures implemented, but when checking for date value in date column, the third cell down is the only value checked in the column. Could be issue if third cell does not have date.

    Please Login or Register  to view this content.
    Last edited by maniacb; 10-16-2020 at 03:52 PM. Reason: remove informational msgbox

  30. #30
    Registered User
    Join Date
    10-11-2020
    Location
    India
    MS-Off Ver
    2013
    Posts
    36

    Re: macro/vba to divide data sheet into two sheet

    Getting error this column needs to have a date.

  31. #31
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: macro/vba to divide data sheet into two sheet

    I think we have different data we are running this code on. Can you run it on the original file you posted. Let's see if that makes a difference. I am thinking the date column may have the trim issue and maybe that is the issue.

  32. #32
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: macro/vba to divide data sheet into two sheet

    I found I had an error with section Pre2. I've updated post #29

  33. #33
    Registered User
    Join Date
    10-11-2020
    Location
    India
    MS-Off Ver
    2013
    Posts
    36

    Re: macro/vba to divide data sheet into two sheet

    Yup running the code on all data sheet. The code you gave in post 13 is perfect just need to resolve the (i)issue of data being not getting pasted to 2nd sheet (ii) after finishing everything naming the a1 to g1 as given in post 14

  34. #34
    Registered User
    Join Date
    10-11-2020
    Location
    India
    MS-Off Ver
    2013
    Posts
    36

    Re: macro/vba to divide data sheet into two sheet

    for code given in post 29
    Even if I use comma and 2nd row number is bigger than first row number, it is forming loop of error message "Don't forget to use commas or use ascending values". I can not proceed further.

  35. #35
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: macro/vba to divide data sheet into two sheet

    Her you go, post #14

    Please Login or Register  to view this content.

  36. #36
    Registered User
    Join Date
    10-11-2020
    Location
    India
    MS-Off Ver
    2013
    Posts
    36

    Re: macro/vba to divide data sheet into two sheet

    still data not getting pasted to 2nd sheet.Only got header in 1st row

  37. #37
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: macro/vba to divide data sheet into two sheet

    Minor difference in sheet activate, that's what I changed last time. It works for me

    Please Login or Register  to view this content.
    Last edited by maniacb; 10-16-2020 at 04:53 PM. Reason: caught error in wsr processing

  38. #38
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: macro/vba to divide data sheet into two sheet

    Maybe there is an issue with the source file we have been using. So here is the file with both sets of code embedded.
    Attached Files Attached Files

  39. #39
    Registered User
    Join Date
    10-11-2020
    Location
    India
    MS-Off Ver
    2013
    Posts
    36

    Re: macro/vba to divide data sheet into two sheet

    The code in post #37 worked perfectly. Now I am marking this post as solved. Thank you for your constant support, patience and kindness.

    Need to filter out (move) some record from "sheet2" (of newly created sheet to some other sheet) on basis of date and match with another list.I was earlier considering this to be done through another macro but if the same can be achieved through this macro then it will be great.

    I used the code written by you to create two sheets section1 and section2 in workbook phase ii (attached). I need to move certain records from sheet2 (section2) to sheet "special and senior" on basis following two conditions
    1) Extract all record of list of special students a given in column B (from section 2 sheet only) and once extracted delete all record of said students from sheet section2 without leaving blank . There are students whose name are same but they are different students.
    2) In sheet 2( section2) students whose date of birth (column k-though in this example this is in column "k" most of time this will be column "C" in sheet 2 of newly created sheet) is greater than date given in cell B12 of sheet "date range" and less than or equal to date given in cell B13 of "sheet date range" , need to be moved to senior student section of "sheet special and senior" row P2 onward with out leaving any blank row in sheet2.

    If you can give some more time it will be great. Thanks again
    encl:phase ii sheet
    Attached Files Attached Files
    Last edited by gautam5; 10-17-2020 at 12:14 PM.

  40. #40
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: macro/vba to divide data sheet into two sheet

    1) This condition isn't clear. Are you asking to remove duplicate birthdays or duplicate names?

  41. #41
    Registered User
    Join Date
    10-11-2020
    Location
    India
    MS-Off Ver
    2013
    Posts
    36

    Re: macro/vba to divide data sheet into two sheet

    1)a)in column B of sheet "special and senior" there are name of certain students
    b) Relevant filed (record) pertaining to each of them should get populated( as values) in "special and senior" sheet
    b) after the the details (record) of said student are populated in "special and senior" sheet, it should get deleted from "section 2" sheet
    What i need is details of special students and
    and students whose date of birth falling between given dates (condition2)
    to be in "special and Senior " sheets only and not in 2nd sheet.
    Nothing to be done to 1st sheet
    Last edited by gautam5; 10-17-2020 at 03:59 PM.

  42. #42
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: macro/vba to divide data sheet into two sheet

    Lets see if this works for you. I wrote code assuming Birthday is in column K


    Please Login or Register  to view this content.

  43. #43
    Registered User
    Join Date
    10-11-2020
    Location
    India
    MS-Off Ver
    2013
    Posts
    36

    Re: macro/vba to divide data sheet into two sheet

    changed the code little bit
    Please Login or Register  to view this content.
    1) The only issue while executing first condition is, if there are two or more different student with same name then it is only populating details of one student, and details of other student is coming blank.But it is deleting record of all the students from section2 sheet.
    2)the 2nd condition is not executing properly .I think I made a mistake while writing if command

  44. #44
    Registered User
    Join Date
    10-11-2020
    Location
    India
    MS-Off Ver
    2013
    Posts
    36

    Re: macro/vba to divide data sheet into two sheet

    Need to incorporate this
    Please Login or Register  to view this content.
    in code u have given at post #37 after

    Please Login or Register  to view this content.
    and after

    Please Login or Register  to view this content.

  45. #45
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: macro/vba to divide data sheet into two sheet

    Code 37 incorporation, I used almost all your code

    Please Login or Register  to view this content.

  46. #46
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: macro/vba to divide data sheet into two sheet

    Post #43. Rewrote code to add "1" to duplicate name so there are no more duplicates. Let's see if this works for you

    Please Login or Register  to view this content.

  47. #47
    Registered User
    Join Date
    10-11-2020
    Location
    India
    MS-Off Ver
    2013
    Posts
    36

    Re: macro/vba to divide data sheet into two sheet

    for post #45 thank you and appreciate your patience.

    For post #46 is there any way we can keep name as it is , and extract record for both of them from section 2 sheet.

    In date just need to modify the condition to >b28 instead of ">=B12 and <=B13"

    Please give a look to my code at post #43
    Last edited by gautam5; 10-18-2020 at 10:39 AM.

  48. #48
    Registered User
    Join Date
    10-11-2020
    Location
    India
    MS-Off Ver
    2013
    Posts
    36

    Re: macro/vba to divide data sheet into two sheet

    #code @post #45 the data did not get pasted to 2nd sheet again.

  49. #49
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: macro/vba to divide data sheet into two sheet

    for post#45, add .activate in the wsr code a few more times, on others, they are wip

  50. #50
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: macro/vba to divide data sheet into two sheet

    Post#47, new code for phase ii. I updated the code to assign dup in column BB, then use that designation to add and correct the special table when there are double names. At the end I remove the data in column BB.

    I also added the .value property for the filter to work for the senior table. Let me know how it works for you.

    Please Login or Register  to view this content.

  51. #51
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: macro/vba to divide data sheet into two sheet

    post #45, here is code that populates the second sheet. Let me know how you fare.

    Please Login or Register  to view this content.

  52. #52
    Registered User
    Join Date
    10-11-2020
    Location
    India
    MS-Off Ver
    2013
    Posts
    36

    Re: macro/vba to divide data sheet into two sheet

    #code 50 getting error Compile "Error: Variable not defined" (I guess lcs2)
    #code @51 the 2nd sheet still coming blank.
    Thanks

  53. #53
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: macro/vba to divide data sheet into two sheet

    #50 lcs2 is the culprit. just add it to the dim line as below:

    Please Login or Register  to view this content.
    #51 I am pulling my hair. have you tried restarting your machine to clear the cache? Still trying some things on my end

  54. #54
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: macro/vba to divide data sheet into two sheet

    #51 Try this code. I rearranged the code.

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macro to fill the data into Summary sheet basis of different scenarios from Data sheet
    By Manish_Gupta in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-19-2016, 11:48 AM
  2. Macro to divide sheet
    By excel1983 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-05-2014, 12:19 PM
  3. [SOLVED] Macro to copy data from a master sheet to separate sheet as per date using a macro
    By tmaster81 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-23-2014, 08:05 AM
  4. Replies: 2
    Last Post: 05-01-2013, 12:26 PM
  5. [SOLVED] Macro to Copy Data from one Sheet A to Sheet B based on value in cell on sheet A
    By scass in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-11-2012, 07:21 PM
  6. Macro/Module running as background process, copy data from sheet to sheet
    By ctor in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-05-2009, 05:48 AM
  7. Need macro to copy data from sheet 1 to multiple pages on sheet 2 in correct cells
    By iturnrocks in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 01-16-2009, 03:33 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1