Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm sorry and feel like an idiot...still can't obtain what I'm trying to
do...:-((( I'm such a newbie with macro & excel... Trying to explain what I need...: In a new workboook I need to copy data in columns (I:J) from 4 different sheets and Every exixsting workbook has 4 sheets called "alfa", "beta", "gamma", "delta". I need to copy (in a new sheet of a new workbook) columns I3:J203 of every sheet for every existing workbook So in the new sheet, I've got From Workbook1 I:J columns from "alfa" in A3:B203 I:J columns from "beta" in D3:E203 I:J columns from "gamma" in G3:H203 I:J columns from "delta" in J3:K203 From workboook2 I:J columns from "alfa" in M3:N203 I:J columns from "beta" in P3:Q203 I:J columns from "gamma" in S3:T203 I:J columns from "delta" in V3:W203 ....and so on And, maybe I wish I could put in cell A1,M1... the names of the workbooks and in A2,B2,C2,D2....the names of the sheets.... really hope you can help me... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
I am an Idiot Woman | New Users to Excel | |||
I want 148:30 converted to 148.5 and I am an idiot | Excel Discussion (Misc queries) | |||
Terrible Excel Ruined My Chances of Graduation | Excel Discussion (Misc queries) | |||
terrible problem | Excel Discussion (Misc queries) | |||
I made a terrible mistake and need help | Excel Worksheet Functions |