Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If value is then copy
Can someone can help me??? I need a VBA code that will say
if value of cell A2 is equal to x then copy G2:P2 to worksheet test2 if value of cell B2 is equal to x then copy G2:P2 to worksheet test3 etc... if value of cell A3 is equal to x then copy G3:P3 to worksheet test2 if value of cell B3 is equal to x then copy G3:P3to worksheet test3 etc... There has to be a faster way??? I have 6 items to check across and 350 down (more will be added. Please note row 2 may have an x in A2 and B2 but row 3 may only have an x in B3..... Thank you in advance |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If value is then copy
Have a look in the vba help index for select case and incorporate into a for/each loop. You don't say where in test2 to copy to -- Don Guillett Microsoft MVP Excel SalesAid Software "Carolina Girl" wrote in message ... Can someone can help me??? I need a VBA code that will say if value of cell A2 is equal to x then copy G2:P2 to worksheet test2 if value of cell B2 is equal to x then copy G2:P2 to worksheet test3 etc... if value of cell A3 is equal to x then copy G3:P3 to worksheet test2 if value of cell B3 is equal to x then copy G3:P3to worksheet test3 etc... There has to be a faster way??? I have 6 items to check across and 350 down (more will be added. Please note row 2 may have an x in A2 and B2 but row 3 may only have an x in B3..... Thank you in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy and paste versus copy and insert copied cells | New Users to Excel | |||
I copy a formula and the results copy from the original cell | Excel Discussion (Misc queries) | |||
copy between worksheets does not copy formulae just values | Excel Discussion (Misc queries) | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
EXCEL FILE a copy/a copy/a copy ....filename | New Users to Excel |